Prevent to open the database

[accessman2]

Hi,

I created the database, which shared by multi-user. But, my user have a problem to open it. When user1 open the database, user2 cannot open it, I did not remember the error message, it is said that Admin (computer name) prevent you to open the database. But, if the user1 switch another application program (the database file is still opened), user2 can open the database, then both users can access the same database file.

Why do we have this problem? How can I fix it?

 

[boblarson]

Somebody's setting in
Tools > Options > Advanced > Default Open Mode
is likely set to Exclusive instead of Shared.

Another good reason to let each user have their own front end and have all of them connect to the back end. That way, it doesn't matter what a user's settings are.

 

[The_Doc_Man]

And if that isn't the problem, then you need to secure the database using something like Workgroup Security. You see, in the default cases (which I believe applies to your setup), every user has the same default workgroup file and comes in as "Admin" account (name look familiar?). By default, Admin account has "Open Exclusive" permissions on the database object as a whole. So... it DOES an Open Exclusive. If you had secured it, you would find that you could prevent this from happening.

Search the forum for topics "Securing a Database" and "Workgroup Security." But I'll add that it might just be a little too much for what you want. The point being that sometimes you don't realize just what you have asked for until you have to do it yourself.