Solved

MS Access 2007 Problem

Posted on 2011-03-16
4
321 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

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…
Quality of Service (QoS) options are nearly endless when it comes to networks today. This article is merely one example of how it can be handled in a hub-n-spoke design using a 3-tier configuration.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

809 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