Limiting Access to one User at a Time

[chris3366]

I have a MS Access Database on a network and want to limit access to one person at a time. The Exclusive feature on the Advanced Tab under options doesn't work. By going thru the Access program to start a database and selecting open exisiting file does work but I am looking for speed and ease of use...As most of you know most users are lazy and do not follow directions very well. I was hoping to try it through code if possible. (Access 2000) is what I am using.
Your help is appreciated and respected.
Thanks
Chris

 

[lupins46]

To force exclusive operation AFTER the database is open you need to open something in design view. It does not need to be visible. So just use a dummy form for this purpose.

No one else will be able to open the database after the first person is in.

But I find it odd that you should want to do this.