How to lock everybody out after I open the database?

G

Guest

Hello,

I am the member of admins group of the database, in the "User and group
permissions" admins & myself have the "Open/Run", "Open Exclusive",
"Administer" permissions for the object "Current Database".
And the group of "Users" only have "Open/Run" of the "Current Database".

But after I opened the databse on the network, I found it still can be
opened by a regular user, which meaning I could not open it in a exclusive
mode. Is there anything else I need to do to lock everyone out if I open the
database first?

Thanks!
 
R

Rick B

Personally, I have a table with one field called "status". My auto-open
form that runs hidden at all times in my front-end databases looks at this
field and closes the database if it is a "1", pops up a ten minute warning
if it is a "2", and lets them in with no problem if it is a "3".
 
G

Guest

Thanks for your response. However, I do not understand very well, for
example, if "Admin" is the current user, and no one else is in the "status"
should be set as "1", right? Then how can I know whether there are other
users connect to the database? And How can I set up to not allowing other
user in if "Admin" already in? Could you give me more details or
instructions? Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top