One Person open a database

L

Lamar

I have a database on network drive. I just want one
person to be able to open the database at a time.

Tools - Options - Advanced Tab and then setting the
Default Open Mode to Exclusive is not working.

Any suggestions? Thanks
 
A

Arvin Meyer

That's more of a network permissions issue. You can limit the database
opening to 1 person editing it by denying delete priviledges for everyone on
the directory. If Access cannot delete the locking file, it will limit
everyone after the first user to read-only status.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
D

Douglas J. Steele

They won't have any problem opening it. All Arvin said was that it would be
read-only for subsequent users.
 

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

Similar Threads

2003 database opening as Exclusive in 2007 3
Shared access 2
Mult-user database won't allow more than one person at a time 5
I cannot open an Access Database exclusively 2
Exclusive mode 4
"Exclusive Access" error message 1
Security-Open Exclusive 8
How do I get exclusive access to my database 1

Top