?
Solved

How do I allow multiple users access to Access 2007 DB at one time.

Posted on 2009-04-10
5
Medium Priority
?
1,129 Views
Last Modified: 2012-05-06
I built a DB in MS Access 2003 and it is currently in .mdb format.  It is located on a server and users used to be able to go in and out of the database regardless of if another was in it.  Now that most of us have Access 2007 the DB is only allowing 1 user at a time.  How can I allow multiple user access at one time?
0
Comment
Question by:ekaplan323
  • 3
5 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 24117856
ensure open mode is set to shared in tools/options
also best to split the database, backend is data, frontend is your code and contains linked tables to the backend
0
 

Author Comment

by:ekaplan323
ID: 24117980
I have Access 2007 and can't find that option?
0
 
LVL 22

Expert Comment

by:dportas
ID: 24118170
For multi-user applications, use a client-server DBMS such as SQL Server. You can still use Access as the front end. SQL Express is free to download and is far more powerful, reliable, secure and better value than Jet (mdb) as a data store.
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 150 total points
ID: 24118233
have a butchers at this http://support.microsoft.com/kb/304932
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 24118384
Not quite the answer you was looking for?
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

599 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