[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1127
  • Last Modified:

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

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
ekaplan323
Asked:
ekaplan323
  • 3
1 Solution
 
rockiroadsCommented:
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
 
ekaplan323Author Commented:
I have Access 2007 and can't find that option?
0
 
dportasCommented:
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
 
rockiroadsCommented:
have a butchers at this http://support.microsoft.com/kb/304932
0
 
rockiroadsCommented:
Not quite the answer you was looking for?
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now