MS Access does not close properly

[Question Boy]

I have an access db that is used in a multi-user environment. In general
90-95% of the users everything works fine. The db works fine, and when they
exit the database closes properly. However, I have 2 specific computer on
which the database appears to close but the process always hangs in the
background.

I should also mention that all computer are running WinXp with runtime 2002.

Would anyone know any good reason why this might be the case or a fix.
Since it is not a generalized problem I`m assuming (there`s a dangerous
thing) that it has to be related to config/update... I am not the admin and
do not have priviledges to validate.

Thank you

QB

 

[a a r o n . k e m p f]

I am so sorry that you are having trouble with Jet.

Jet was never designed as a multi-user database.

If you want reliable database for Access, move to Access Data Projects

The problem that you're facing is probbaly because you're using DAO
and you're not explicitly closing and set rst = nothing for _ALL_ of
your DAO objects.
That to me-- is a prime reason not to use DAO.

Any library that isn't smart enough for clean up variables (when they
go out of scope) is a library that is not good enough for me.
Any library that isn't smart enough for clean up variables (when they
go out of scope) is a library that is not good enough for me.
Any library that isn't smart enough for clean up variables (when they
go out of scope) is a library that is not good enough for me.

-Aaron

 

[BruceM]

Ignore Aaron. He is consistently irrelevant. If you are having problems
with just a few installations it probably is not the code. One thing to
check is whether all users have full permissions to the folder in which the
database file is located (or where the back end file is located if the
database is split).

Be sure all computers have the latest updates, of course.