blocking access to more than 1 user

[Guest]

Is it possible to program Access so only 1 user at a time can use a
particular database? If a second user tries to open the database, I would
like them to get a message that the database is in use. Thanks

 

[Roger Carlson]

I can't see why you would want to do this, but...

The simplest way is to use Network Rights. Restrict all the users from
having CREATE rights to the DIRECTORY where the application resides.
Without CREATE rights, Access cannot create the LDB (locking) file and any
other instance of Access that tries to open the database will think it has
been opened Exclusively. Others can open it, but in Read-Only mode.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Tim Ferguson]

Is it possible to program Access so only 1 user at a time can use a
particular database?

Open it with Exclusive access?


Tim F