Solved

MS Access 2007 Problem

Posted on 2011-03-16
4
320 Views
Last Modified: 2012-05-11
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
Comment
Question by:yoyoma788
4 Comments
 
LVL 4

Assisted Solution

by:cavp76
cavp76 earned 167 total points
ID: 35151572
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
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 167 total points
ID: 35151578
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
 
LVL 6

Assisted Solution

by:RKinsp
RKinsp earned 166 total points
ID: 35151593
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
 

Author Closing Comment

by:yoyoma788
ID: 35165775
good stuff
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the hope of saving someone else's sanity... About a year ago we bought a Cisco 1921 router with two ADSL/VDSL EHWIC cards to load balance local network traffic over the two broadband lines we have, but we couldn't get the routing to work consi…
The Cisco RV042 router is a popular small network interfacing device that is often used as an internet gateway. Network administrators need to get at the management interface to make settings, change passwords, etc. This access is generally done usi…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now