MS Access 2007 Problem
Posted on 2011-03-16
I’m having a client send a database out to 100 different locations. Each location has to save and use the database we’ve created. Multiple users must be able to access this database concurrently to continuously updated over the course of about 2 months.
My thoughts and failures:
Splitting the database allows multiple users to access it and work on it concurrently (so they say), having the back end to be saved onto a shared drive and the front end to be distributed to the users. I’ve split it and saved onto a shared drive but when one person opens it, it locks out any other user. I’ve taken “locks” off and it still doesn’t work.
We cannot save it onto a client-wide central server due to a myriad of reasons, so it has to be distributed to these 100+ locations.