unable to log out of access

[AccessDevJunior]

hya

i am able to view all the users logged into my database, the thing is there is no one logged in not even myself but yet windows explorer still shows the '.ldb' file which appears when some one is in the file, also i am unable to rename the file or delete the file because there is a sharing violation and my computer name appears as the one being logged in the database even though im not.

i tryed logging off my computer and still this dosnt work.

anyone got any ideas to get round this?

 

[RickSpr]

When an .ldb file is on a network drive, it sometimes hangs around after the last user closes the database. This is normal, and occurs because the last user doesn't have access permissions to delete a file in the server's folder.

Nevertheless, this does not mean that the .mdb file is locked, nor does it mean that Access thinks you're logged into the database. The username/computername entries in the .ldb file are not erased when you log out. There is a set of bits somewhere that indicates which entries are currently in use; if the bit for an entry indicates that the entry is not in use, then the username/computername is meaningless.

If your database is, in fact, locked because some user exited without shutting down Access (power failure, reboot, etc.), then you need to delete the .ldb file. You must find somebody with delete permissions on the server to do that.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein