exclusive open mdb file in network environment

[virginie]

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

 

[timfoster]

Probably the easiest way to do this is to use the exclusive switch in your shortcut.

create a shortcut for your users as follows:
c:\database.mdb /excl

Obviously, c:\database is the path to your db.

This isn't a very good way of securing a database though.