Why does setting database to open exlusively not work?

[jaydh]

I am trying to get a database to only allow one user at a time.

I've tried setting the advanced options default opening mode to 'exclusive'
but other users can still get in when I've got it open.

Any ideas why this isn't working, and any other suggestions for restricting
the database?

Thanks

 

['69 Camaro]

Hi.

I've tried setting the advanced options default opening mode to
'exclusive'
but other users can still get in when I've got it open.

That's not guaranteed to always work. Access will attempt to open it in
exclusive mode, but if it can't, it will still open, but in shared mode.
One can ensure that the database is opened in exclusive mode by always using
the command line switch /excl in a Windows shortcut. Ensure that the full
path to the Microsoft Access executable is in the target. Otherwise,
Windows will do the default action with the Access program: open it without
any command line arguments. For example (all one line):

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\MyDB.mdb"
/excl

Anyone who attempts to open the database after you've opened it exclusively
will receive an error message, and the database won't open for them.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.