Exclusive access not working...

[RiazKhanmohamed]

Hi, thanks for reading.

I have a database in Access 97 on a company network drive. I have set it to exclusive via the Tools>Options menu, I've created a shortcut with the /excl command line code to force exclusive use. However I can still open up a million copies of it.

I've read users who say if another user tries to open an exclusive database then they get a message saying it's already in use and they can't get in, and they don't want this. I DO want this message. the database relies on not being used by more than one person at a time, and so will cause loads of errors if more than one person opens it.

Any/all ideas would be greatful.

 

[DougP]

Have you tried to open it from another computer or all copies on the same computer?

DougP, MCP

 

[RiazKhanmohamed]

I've tried both. Managed dupes on mine, then while i had a few open, tried opening it on 2 other machines and they had no probs opening it either. all said in the options screen that it was on exclusive.

Thanks for responding