/excl switch

[Tiro Cupidus]

I've made a post about it before, but I didn't really get anywhere with it, so here's a related, but slightly different topic.

If I set the target of a shortcut to a database as:

path\db.mdb /excl

why would it not open as exclusive? The only way I can seem to successfully open exclusively is to go to File->Open, navigate to the database, and open it.

 

[Tiro Cupidus]

Or any other suggested way of making sure a database is open by only one person at a time would be appreciated. Also, I don't have access to these users' computers.

 

[ghudson]

This works for my shortcut with Access 97.

"C:\Program Files\Microsoft Office\Office\msaccess.exe" C:\MyDatabase.mdb /excl

To test it...open the db with the /excl shortcut, then try to open the same db anyway you can.

You should get the error message "Couldn't use 'C:\MyDatabase.mdb'; file already in use."

HTH

 

[Tiro Cupidus]

Forgot to mention I'm using Access 2000.

I tried that at home and it worked fine. I'll give it a shot at work tomorrow. Thanks for the help. =)

p.s.
What if the user has msaccess.exe in a different location? (unlikely, but possible)

 

[IgorB]

Then specify location for user individually.
First, search "msaccess.exe" in MyComputer. It could be more than 1 if you installed MS Access97 and 2000 versions on the same computer.

 

[Tiro Cupidus]

They all need to use the same shortcut and (look above ) I don't have access to their computers.