Only one user at a time in the database

[Guest]

How do I make it so that only one user can access our database at a time?

I want to save the database (db) so that when I'm in the db no one else will
be able to open it. Or if they do then they will get a message saying a 'You
can only open as read-only b/c someone else is using it right now. Do you
want me to notify you when they are out' message will appear. And vice-versa,
when someone else is in the db, I should get a message saying someone else is
using it, etc. you can only open as read-only, etc.
Currently I have to go around the office and ask if anyone is in the db
before I open it to make changes.
Can someone help with this?

Regards...Studebaker

 

[Ken Snell \(MVP\)]

Might be better to split the database to a front end (each person has
his/her own copy) and a back end (each front end links to it). The front end
has forms, reports, queries, etc. in it; the back end has the data tables.
See these articles for more information:
http://www.granite.ab.ca/access/splitapp/index.htm
http://www.allenbrowne.com/ser-01.html

Otherwise, if you want to open the database in an exclusive mode, create a
shortcut on your PC with a target string similar to the following type of
string (replace generic names with real names), which uses the "exclusive"
switch for opening the database (note that this string assumes MSACCESS.exe
file is in the indicated path -- change it if that is not where you copy of
ACCESS is stored):

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"C:\FolderName\DBFileName.mdb" /excl