Exclusive Use

[Kenln]

Is there a way to have the db open exclusive normally?

I set the Tools -> Options -> Advanced -> Default Open Mode = Exlusive

But when you double click on the Application it open normally, i.e. shared use?

Any ideas?

 

[The_Doc_Man]

Look up (in Access Help) the "Command line options"

Create a shortcut to open the database.

Now right-click the shortcut to see its properties. It will include that it is running Access and it will show the name of the database. Edit the implied command line to include the option for opening exclusively.

Note that if you have a secured database (using Workgroup Security), you might not have PERMISSION to open the DB exclusively.

 

[Kenln]

Yeah, I guessed that was a way. This is going to be deployed on a server with multiple people accessing it which was easier than creating short-cuts on everyones desktop.

I was hoping to find a way via VB, AutoExec, options or somehows that whoever opened it first had exclusive access. Or similar to Excel (without share) that anyone else had read only.