J
Jeff Vandervoort
Access "guru" at one of my clients has an Access 2000 MDB file with a fair
number of macros in it. One of them works fine when it works, other times,
you click the button, see a wait cursor for a few seconds, then nothing. No
error message.
We've tried this on lots of machines under several user accounts and can't
find any sort of pattern. On some machines no user can run it, on some
machines only certain users (different on each machine) can run it, on some
machines any user can run it. The network is an NT Domain with roaming
profiles, so the user account and profile is identical on all machines
despite different results on different machines at different times.
System is a mix of Access 2000 and Access 2002 machines on Win 2000 SP4 and
Win XP SP1. There is no pattern with OS and Access versions. The application
is developed on an Access 2002/Win XP SP1 box.
On one recent test, we found it would not run several times, but then it
just started running in the same Windows session as it had not been running
in seconds before. Generally we've not seen that.
To me, this last event in particular points to a corruption in the MDB file.
Compact and repair halved the size of the file, but did not fix the problem.
Any idea how to fix it?
number of macros in it. One of them works fine when it works, other times,
you click the button, see a wait cursor for a few seconds, then nothing. No
error message.
We've tried this on lots of machines under several user accounts and can't
find any sort of pattern. On some machines no user can run it, on some
machines only certain users (different on each machine) can run it, on some
machines any user can run it. The network is an NT Domain with roaming
profiles, so the user account and profile is identical on all machines
despite different results on different machines at different times.
System is a mix of Access 2000 and Access 2002 machines on Win 2000 SP4 and
Win XP SP1. There is no pattern with OS and Access versions. The application
is developed on an Access 2002/Win XP SP1 box.
On one recent test, we found it would not run several times, but then it
just started running in the same Windows session as it had not been running
in seconds before. Generally we've not seen that.
To me, this last event in particular points to a corruption in the MDB file.
Compact and repair halved the size of the file, but did not fix the problem.
Any idea how to fix it?