Home > IT Answers > Microsoft Windows > Access Database Splitting
Randrae
15 pts.
 Access Database Splitting
Access 2007, Access Database, Access Database Design
I just split a database because there are multiple people using it and we started having problems with people not able to get into the database while someone else was in it. I moved all the tables to the back-end and created links to the tables in the front-end. After doing this we tested out. The result... there's still a problem. What other issues could cause this?

Software/Hardware used:
MS Access 2007
ASKED: June 15, 2011  8:07 PM
UPDATED: June 20, 2011  11:30 AM
RELATED QUESTIONS
Answer Wiki:
Did you make sure that everyone is opening it in Shared mode? Also, you may want to make sure everyone has the same version and SP installed.
Last Wiki Answer Submitted:  June 16, 2011  1:43 pm  by  Randym   1,740 pts.
All Answer Wiki Contributors:  Randym   1,740 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I verified that everyone is opening it in shared mode and we all have the same version and SP installed.

Randrae
 15 pts.
 

It sounds to me like a record locking issue. Look at the Microsoft help page for record locking.
http://office.microsoft.com/en-us/access-help/set-options-for-a-shared-access-database-mdb-HP005188297.aspx

tlsanders1
 1,290 pts.
 

If you need a mutli-user database wouldn’t something like SQL or MySQL be better?

ErroneousGiant
 3,120 pts.