Solved

MS Access 2007 Problem

Posted on 2011-03-16
4
324 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

696 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