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?
ekaplan323Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
rockiroadsConnect With a Mentor Commented:
have a butchers at this http://support.microsoft.com/kb/304932
0
 
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:
Not quite the answer you was looking for?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.