.mdb file does not open if someone already opened it.

5 pts.
Tags:
.mdb files
Access Database
I noticed one sad thing while i had been working in Access 2003. I and my colleagues are using shared .mdb files. And the strange thing is that no one of us can open an .mdb file by double click IF it opened yet by someone first. My colleague tried to reassociate all .mdb file types with Access, but it gave no result. If file doesn't open everything worked fine, since last week. Now we cannot open it at all. And maybe it got corruption..i think these events are linked with each other. 
I will be grateful for any ideas.


Software/Hardware used:
Access database 2003
1

Answer Wiki

Thanks. We'll let you know when a new response is added.
Opening file by double click and opening it through the Access are not the same. At the first case it would be a sort of private mode and therefore there are no surprise that no other users can use and change it. Opening files under Access must solve the issue. 

What about your corrupt files, i would run “Compact and Repair” at first. It accessible from the Tools/Database Utilities menu. It might help.

Access while opening creates a .ldb file. It is not needed technically. Find it and delete, it can be hidden, therefore change your settings to see it. 

If you have tried all the tips and no one helps, then maybe it is time for running a third-party. I would suggest Recovery Toolbox for Access https://access.recoverytoolbox.com/  it really can help in the issue and save your time and nerves. 

Discuss This Question: 1  Reply

 
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.
  • DPaxton
    What is the "Open Option". Is it "Shared" or "Exclusive"? If it is Exclusive then change it to Shared. Also make sure that all forms are closed when not being used. This can cause a database to be lock.
    245 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.

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

Following

Share this item with your network: