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

[Tom van Stiphout]

On 1 Dec 2003 12:48:39 -0800, tr**********@inet.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

[David W. Fenton]

tr**********@inet.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