Trouble opening database with user in it

[tanhus]

I've built a database where it is setup as a shared database. The problem I
am having is when another user is in the database, I am having trouble
opening the database when double clicking on the mdb. It doesn't do anything.
However, when i open the database through Access (File->Open) I have no
problems getting into the database. How can i solve this problem? Thanks to
those who can help.

 

[Jerry Whittle]

What are you double-clicking: the .mdb file in Windows Explorer or a shortcut
on your desktop? What happens if you try to open the database when no one is
in it. Are you sure that when going to File, Open that you are actually
opening the same file as the other user?

 

[tanhus]

I'm double clicking the actual .mdb file the other user is in. If no one is
in it, anyone can double click the file and go in. Yeah i am sure that im
going to the same file.

 

[Jerry Whittle]

All users need read, write, create, and delete privileges to the folder
holding the .mdb file. Not just the file itself but the entire folder. Also
check to see if there is a .ldb file in the folder with the same name as the
database when you are sure that everyone is out of it. If so, delete this
file. If you can't, then you don't have the right permissions to use the
database. The .ldb file allows multiple users in the database and if it can't
be created, deleted, or edited, it can't keep track of who is who.