Solved

Opening Access 2013 Database error

Posted on 2016-11-11
7
36 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

This article will show you how to use shortcut menus in the Access run-time environment.
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
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…

776 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