Solved

Opening Access 2013 Database error

Posted on 2016-11-11
7
33 Views
Last Modified: 2016-11-27
I have a user that created an access Database, this database is located on a share folder so other users can access it.

 I am getting this error message "the database has been placed in a state by user "admin" on machine "Machine" that prevents from being opened or locked.

Not sure how to troubleshoot this issue.
0
Comment
Question by:sanchez2077
  • 3
  • 2
  • 2
7 Comments
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 41884061
You may have a hanging lock file. Close the database, then look in the folder for a file named <yourdatabasename>.ldb. If you find that file Delete it - it's a lock file that Access creates as needed, and if it's left behind can cause the issue you report.

If you can't delete it, you may have to reboot the machine, or use one of the "unlocker" utilities to release the system lock on the file.

For good measure, you should also Compact the database. Be sure to make a backup first.
1
 
LVL 19

Assisted Solution

by:crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access earned 250 total points
ID: 41884225
it is important to realize that multiple users should NOT be sharing a database with user interface objects such as forms and reports.  For multi-user applications, the tables are in one database that CAN be shared. This is called a back-end, or BE.

The front-end database (FE) contains queries, forms, reports, macros, and modules and links to tables in the back-end database. Each user should have their own FE.

No users should be opening the BE directly but it could still be locked if any of the users have the FE open.

Even though you may not be able to open the database, you can probably copy it and give it a different name.
1
 

Author Comment

by:sanchez2077
ID: 41888326
Thank you all for your replies. This morning I got a different message when trying to open the same database.

"Cannot open database" it might not be a database that your application recognizes, or the file might be corrupt. "
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 41888450
You may have some corruption in your database. To fix that, first make a backup and then do this:

1. Compact the database
2. Compile your code - from the VBA Editor click Debug - Compile. Fix any errors, and continue doing this until the Compile option is disabled
3. Compact again

You may also need to decompile your database. Make a backup then create a standard Shortcut with a Target like this:

"full path to msaccess.exe" /decompile

Run that shortcut and open your database. Access will decompile your database when it opens. After it opens, run the 3 steps again.

If you still have troubles you may have a corrupt form/report, or a corrupt database container. Create a new, blank database and import everything into the new database. If that doesn't fix the issue, you may have to recreate the form/report from scratch, or from a known good backup.
1
 

Accepted Solution

by:
sanchez2077 earned 0 total points
ID: 41897678
Thank you all for the suggestion on finding the solution to this issue. I ended up recovering from our latest back-up and this fixed the problem.
0
 
LVL 19
ID: 41897699
you're welcome -- glad you are back in business :)

btw, be sure you do NOT select Compact on Close in the options. Compacting should only be done right after a database is backed up -- and when you first open it
0
 

Author Closing Comment

by:sanchez2077
ID: 41902976
We recovered from our latest back-up and this worked.

Thanks,
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now