General discussion


Microsoft Access Database Sharing

By ljackson.desoto ·
I have set up a database on a shared drive for everyone to access the database. This is a peer-to-peer network setup. The database is set to open as shared by default(tools, options, advanced, shared). When any of the computers open the database, none of the other computers can open the database except for the server.

So, if the server or any remote computer opens the database first, the other remote cannot open. I put this same database on another network that is supposed to be set up the same (same company, two stores, same company set up the network) and it works fine. Help!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by ESchlangen In reply to Microsoft Access Database ...

Two things come to mind.
First, each individual copy of Access should be set to open databases in shared mode by default OR you should create a shortcut that uses the command line switches to open the database in shared mode.
Second, to use Access, a "locking" database (*.ldb) must be created. By default, this is created in the same folder as the .mdb file. Your users MUST have write permissions to the folder, both NTFS and Share, to do this. They do not necessarily need write permissions to the .mdb file itself, if you want to protect the data.

Hope one of these helps!

Collapse -

by ljackson.desoto In reply to

Thanks for the answer. It didn't help for this situation, but it is good info for the future. Figured out it has something to do with the way the network person set up the shared network folder. If I created a short-cut directly to the network drive it would not work, but if I created a short-sut via a shared folder pointing to the network drive it did work. I couldn't tell you why. Thanks for answering, you get the points anyway.

Collapse -

by ljackson.desoto In reply to Microsoft Access Database ...

This question was closed by the author

Related Discussions

Related Forums