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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok, perhaps deleting the ldb is not the best alternative. I wish I could find out who was logged in.
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