Want only one person to edit database at a time.

[marathonlady]

Is there a way to set an access2000 db so only one person can edit the db at a time? I went into Tools,Options, Advanced and see there is a Shared/Exclusive option, but I heard that sets all of your databases to what you select here.

Thanks in advance for any help.

 

[Autoeng]

You can set the db to open in "Exclusive" mode by specifying it in the shortcut. See here...

http://www.access-programmers.co.uk...=&threadid=46882&highlight=code+and+exclusive