Single User Access

J

Jerry Spivey

Hi,

I have an employee who has placed an Access 2002 database on a shared drive.
He'd like the file to be open by only one person at a time. If someone else
tries to open the file while the file is currently open by another user the
second open attempt should fail. I've set the Exclusive property for the
..mdb file but it does not work. Another person can open the same file and
when they do the file is in Shared mode even though the file is in Exclusive
mode.

How can I limit the use of the database to only one user at a time?

Thanks for any input.

Jerry
 
A

Allan Murphy

Jerry

Try the following

Select TOOLS on the Menu Bar

then OPTIONS

then ADVANCED folder

then set the default open mode to EXCLUSIVE
 
J

Jerry Spivey

Yeah that's what I did but there was some KB article that said it wouldn't
work unless you opened it X way.
 
Top