Solved

Access Database in Multi-User enviroment

Posted on 2007-04-05
6
806 Views
Last Modified: 2013-11-28
What steps should I take to ensure optimal functionality of an Access Database in a multi-user (2 - 10 users) environment?  By the way, there are several sub-forms, which seems to complicate the issue.
0
Comment
Question by:Saleve
6 Comments
 
LVL 15

Expert Comment

by:cquinn
ID: 18858686
Split the database between a frontend (programs) and backend (data) and give each user a local copy of the frontend, linked to the back end on a network share
0
 
LVL 13

Expert Comment

by:adraughn
ID: 18858724
cquinn is right. here is a linkt o additional info on splitting:

http://www.databasedev.co.uk/split_a_database.html
0
 
LVL 6

Expert Comment

by:twintai
ID: 18859473
All previous posts are correct - Split. Before splitting, make sure to make a back up copy of the Db in case something funky happens.

Also, if each user has separate needs I would restrain from creating a different Front End for each user. Instead, have one FE Db and create permissions for certain portion of the FE DB.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 13

Expert Comment

by:adraughn
ID: 18859507
twintai,
saleve does need to have a front end for each user. not because they have "special needs" but because he is going to split the database.
as cquinn stated, all users should have a local "copy" of the front end on their machine to prevent locking. this is a standard setup for a split database.

adria
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 18859546
Assuming you have already split the database into a FE/BE scenario, here is a recent EE thread with a load of good information and things to consider.  This is not a black and white subject.  Let me know if you have any further questions :-)

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_22421098.html

Also ...even though a bit lengthly ... and yet unresolved ... this gives you an idea how what can 'come up' ... so to speak, but not meant to scare you:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22455306.html

mx
0
 

Author Comment

by:Saleve
ID: 18863169
Thanks to everyone who answered.  I had actually already split the database. Since reading the links provided by MX, I realize that I should have asked more specific questions.  I will do this separately.
Regards,
Saleve
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Close Print Preview button not active 12 35
Query to summarise data Like Pivot Table 3 28
Access 2010 Query Syntax 5 15
Format a Field AFTER UPDATE 5 18
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

932 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

10 Experts available now in Live!

Get 1:1 Help Now