Runtime in Access 2000 databases after upgrade to Windows 2000

Trevor Hughes

Hello All

Our organisation has recently upgraded its operating system to Windows
2000. Prior to this I was running Access 2000 databases on NT
machines using the Access 2000 Runtime with no problems.

Since the upgrade I am experiencing runtime errors which are making
parts of the database unusable. The database will crash when I run a
report. One of the problems relates to formating problems surrounding
reference libraries. I have changed the refernce libraries but the
changes do not stay. The next time I open the database the reference
libraries change back to the original settings.

Our organisation has a security policy on certain parts of the hard
drives which write protects folders such as Program Files and WINNT.
I think that this could be the route of the problem.

If any-one has experienced similar problems and has found a solution I
would really appreciate hearing from you.

TIA

Trevor

Nov 12 '05 #1

Subscribe Reply

2508

Tom van Stiphout

On 1 Dec 2003 12:48:39 -0800, tr**********@in et.net.nz (Trevor Hughes)
wrote:

I am not aware of Access needing write access to those locations,
unless that's where your system.mdw is. But with policies like that,
who knows where it ends? I think Access updates the registry. Perhaps
that's fobidden too?

Try it on an unprotected system, or using a superuser account with
full access.

-Tom.

Hello All

Our organisation has recently upgraded its operating system to Windows
2000. Prior to this I was running Access 2000 databases on NT
machines using the Access 2000 Runtime with no problems.

Since the upgrade I am experiencing runtime errors which are making
parts of the database unusable. The database will crash when I run a
report. One of the problems relates to formating problems surrounding
reference libraries. I have changed the refernce libraries but the
changes do not stay. The next time I open the database the reference
libraries change back to the original settings.

Our organisation has a security policy on certain parts of the hard
drives which write protects folders such as Program Files and WINNT.
I think that this could be the route of the problem.

If any-one has experienced similar problems and has found a solution I
would really appreciate hearing from you.

TIA

Trevor

Nov 12 '05 #2

David W. Fenton

tr**********@in et.net.nz (Trevor Hughes) wrote in
<27************ **************@ posting.google. com>:

Our organisation has recently upgraded its operating system to
Windows 2000. Prior to this I was running Access 2000 databases
on NT machines using the Access 2000 Runtime with no problems.

Since the upgrade I am experiencing runtime errors which are
making parts of the database unusable. The database will crash
when I run a report. One of the problems relates to formating
problems surrounding reference libraries. I have changed the
refernce libraries but the changes do not stay. The next time I
open the database the reference libraries change back to the
original settings.

Our organisation has a security policy on certain parts of the
hard drives which write protects folders such as Program Files and
WINNT. I think that this could be the route of the problem.

If any-one has experienced similar problems and has found a
solution I would really appreciate hearing from you.

The problem might be unrelated to Win2K's better security model.

A couple of things to think about:

1. Win2K's Active Directory uses Jet 4 to store its data. This
means that Jet is now a part of the OS. Upgrade to at least Jet 4
SP6 (the jury is still out on SP8 -- SP7 is definitely a no-go, as
SP8 is the bug fix for it).

2. Make sure the Access installations are Access 2K SR1a or later.
That means that you may need to rebuild your runtime and re-install
it.

3. If the machines were upgraded from NT 4 without wiping the
drives, perhaps permissions have been restricted on the Profiles
folder, which in NT 4 was under the WinNT folder. User profiles in
fresh installations of Win2K are under %SystemVolume%\ Documents and
Settings\.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 12 '05 #3

Similar topics

5160

MS Access 2003 Runtime Environment

by: Mike | last post by:

Hi Hi We are currently upgrading from access 97 to office 2003 on site. We would like to upgrade our access databases to Access 2003 but we wish to remove Microsoft access software from our end users so that we can control the creation of databases. Is there a way that our end users can still use these upgraded access databases without having access 2003 installed on their machines. The mdes will reside on a server so they can be...

Microsoft Access / VBA

4389

Access 2002 runtime error for Windows XP

by: Aliza Klein | last post by:

Apologies in advance as I am SURE this has been asked 100 times - but I haven't got a simple answer: I have MS Office XP Developer and have created an installation package (with the runtime) for an Access 2002 database. The problem: when installing on a Windows XP machine, I get the following error: The Office System Pack cannot be installed on this system because it

Microsoft Access / VBA

4513

Advice needed: Should we upgrade MS Access 2000? And if so to what?

by: ship | last post by:

Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small company and this is a big decision for us(!) It's not just the money it's committing to an new version of Access!

Microsoft Access / VBA

2058

Advice on upgrading 97 runtime app to 2003

by: Owen Jenkins | last post by:

I have an Access application that is being used by 150+ clients. I develop in 97, convert to 2000 and distribute as a 97 or 2000 mde, or 97 runtime. This limits me to 97 functions. My clients may use any one of Access 97, 2000, 2002, 2003 or 97 runtime. So that I'm not lingering too far behind, I'm thinking of developing in 2003, using 2000 file format and distributing a 2000 mde for users of Access 2000+. (I understand I'll need to use...

Microsoft Access / VBA

9954

Access 2002 vs. 2003

by: Neil | last post by:

We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server 2005, and, since he already has licenses for Office Pro 2002, he wants to upgrade to that. I've been saying that we need to upgrade to Access 2003, not 2002, even if Office is kept at 2002. We are also looking to do a fair amount of...

Microsoft Access / VBA

4403

Ms Access 2003

by: Mell via AccessMonster.com | last post by:

Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting there, but is there a way they can find out if that application was put there from a CD or email or created at work? Hint: It's not on a client/server database, just native jet database mdb created on Access 2003 (default 2000)...

Microsoft Access / VBA

13243

MS Access 2000 Database Problem with Vista

by: yolenman | last post by:

Hello - This is my first posting to this group, so please bear with me. Also note, that while I'm intelligent, databases are not in my field of knowledge. I'm working with a small limousine company. They presently have about 4 networked computers, all running Windows XP (w/SP2) and Microsoft Office 2000 (specifically Access 2000) - and a plain jane p3 server also running Windows XP (w/sp2) with Office 2000 loaded onto it. These...

Microsoft Access / VBA

2768

Thinking of upgrading runtime from Access 97, but which version to get?

by: ARC | last post by:

Hello All, I have a major application for quoting and invoicing that is written in Access 97 (both front and back ends). I have a user base of over 300 customers, and currently I don't require that they have Access 97, as I use the access 97 runtime scripts from Sagekey software. The main problems I've seen with Access 97 are the built in e-mail support for sending reports. Unless a user uses the MS Outlook 2000/XP method, they have to...

Microsoft Access / VBA

1323

DAO to ADO Access 97 -> Access 2000 very slow VB6

by: adstheman | last post by:

Hi all, I am maintaining a group of applications which share Access databases. In the newer version of the software products we have upgraded from DAO to ADO and also implemented routines to upgrade the databases from Access 97 to Access 2000. However, bitmaps stored in the Access 97 databases when retrieved into a recordset using the older versions of our software (that used DAO) were accessed at a good speed. However, in the newer...

Visual Basic 4 / 5 / 6

8249

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8179

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8685

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

7176

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6112

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4187

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2613

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1797

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1493

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General