open exclusive db file on network

[vivou]

hi!

i have a db that sits on network.
this is a multi-user db, where i want to lock access to anyone when someone open it.

so i try, according to ms-access help, the "open exclusive" .
i set the option "open exclusive" instead of "shared" in menu-> options-> tools->"advanced" tab.

but this has NO effect, i try to open the mdb file on another computer via the network, when it is open in mine, and actually, i success that without problem, even a message that someone already open it i didn't see!

what can i do?
i want to do it very simply, without real security or password,
just lock the file to avoid parallel access....

i want to add here that when i tried it over and over again, sometimes it did work, sometimes not, very wierd!

what suggestions have you about that ??

 

[The_Doc_Man]

Actually, you are trying to do something that most systems are not set up to support. They are all designed to share data, not lock it. Part of the problem is that everyone's copy of Access and everyone's shortcut has to be set to Exclusive. You want it exclusive, you get it if and only if it is not already shared.

Or, you can force exclusive access if you open it without using a shortcut, by Browsing for the file and checking the Exclusive Open box.