Software

Ask something
Discussion Locked

Microsoft Access Database Sharing

0 helpful
3 replies

by ljackson.desoto

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!

3 replies

by eschlangen

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!

by ljackson.desoto

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.

This discussion is closed to new replies.