Access Database Splitting

15 pts.
Tags:
Access Database
Microsoft Access 2007
Microsoft Access database
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Randrae
    I verified that everyone is opening it in shared mode and we all have the same version and SP installed.
    15 pointsBadges:
    report
  • tlsanders1
    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
    1,340 pointsBadges:
    report
  • ErroneousGiant
    If you need a mutli-user database wouldn't something like SQL or MySQL be better?
    3,120 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following