single user mode

[viswanathan]

hi,
I trying to set my access database as a single user mode.
(If i using the Mdb , other user cant use the same mdb by showing some warning msg and close )


Please lead me for that.

[ranman256]

This usually works naturally if you have a single db (not split). When 1 is in it, the 2nd user will get a warning.

[viswanathan]

ya, second user get warning, but i want the another user cant open the db, at the time i using the db

[John_G]

Try setting your copy of MS Access to open exclusive:

File - Options - Client Settings - Advanced and set Default open Mode to Exclusive.

However, be careful using this, because it means ANY database you open will be opened in exclusive mode.