Solved

MS Access 2007 Problem

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

757 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

20 Experts available now in Live!

Get 1:1 Help Now