Trouble opening database with user in it

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tanhus - 05 Apr 2007 15:56 GMT

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.

Reply to this Message

Jerry Whittle - 05 Apr 2007 20:14 GMT

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?

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> 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.

Reply to this Message

tanhus - 05 Apr 2007 21:22 GMT

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.

> 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
[quoted text clipped - 7 lines]
> > problems getting into the database. How can i solve this problem? Thanks to
> > those who can help.

Reply to this Message

Jerry Whittle - 06 Apr 2007 03:36 GMT

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.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> 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
[quoted text clipped - 11 lines]
> > > problems getting into the database. How can i solve this problem? Thanks to
> > > those who can help.

Reply to this Message