• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 333
  • Last Modified:

MS Access 2007 Problem

Problem:  
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.
0
yoyoma788
Asked:
yoyoma788
3 Solutions
 
cavp76Commented:
Access DBs are not designed for this kind of job... the best route is to use a SQL server, then you won't have lock problems... or a common front-end for all the clients. Either way, it's necessary to keep in a central location
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Sounds like you are having multiple users open the same copy of the front end?  If this is true tehn that is the problem.  Every user need tho have their own non-shared copy of the front end.
0
 
RKinspCommented:
You also have to enable Shared mode i think. But 100+ locations is above what Access should be used with.

I'd migrate you DB to SQL. You can still use Access as a front end.

-RK
0
 
yoyoma788Author Commented:
good stuff
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now