Link to home
Start Free TrialLog in
Avatar of mranders
mranders

asked on

What to do when users don't exit an Access 2003 database and you have a lock file

I want to take a database offline for maintenance but there is an .ldb file.
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Your options:

1) If you are sure no one is actually 'using' the mdb, you can reboot that suspect user's workstation.

2) Or ... the server if necessary

3) You can, but not really recommended ... actually copy over an MDB with a new or different version, ie. one that you have done maintenance on ... even if there is and existing LDB.

mx
Avatar of mranders
mranders

ASKER

I see. Thanks. Everything in my database is saved instantly. The user never has to push a 'save' button or anything like that. What would happen if I simply tried to delete the ldb?
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Ok, perhaps deleting the ldb is not the best alternative. I wish I could find out who was logged in.