Question Shared usage

[waltjo]

I am in the processes of seting up a database for multiusers.
However even with the advanced options setting for default open mode set to shared it will only open on a single machine.

Any ideas as to the cause?

thanks

john

 

[DCrake]

Have you split the database between front end and back end? I fear not. Each user should have a single instance of the front end on their workstation which is linked to the back end data tables mdb in a shared location.

David

 

[waltjo]

David,

Splitting the database was my next step in its role out to other users but I was not aware that until done this would restrict is multiuser accessability.

I will certainly split the database now and check for shared usage.

john

 

[irish634]

Splitting the database and putting a copy of the front end on each user's PC is one of the rules for multi-user environments. Have a look at the Ten Commandments thread.

By not splitting your database, it's just a matter of time until something becomes corrupt.

To answer your question about why only one user can access the database at a time: When I came to work at my present job, there was a DB on the network that was not split. When one user had the DB open, the others could not double-click on the file to open it.

BUT... you could open Access, then use "FILE" --> "OPEN" browse for the file, and open it that way. I'm not 100% sure why it worked this way, but maybe your situation is similar.

That was the very first thing I fixed... I split the DB and gave each user a copy of the FE.

Craig

 

[Rabbie]

Try looking in your DB properties. It may be you are opening the the DB in Exclusive Mode. As the name implies only one user can have it open at a time then.