Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Opening Access 2013 Database error

Posted on 2016-11-11
7
Medium Priority
?
41 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:Mario Gonzalez
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 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 22

Assisted Solution

by:crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access earned 1000 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:Mario Gonzalez
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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 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:
Mario Gonzalez 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 22
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:Mario Gonzalez
ID: 41902976
We recovered from our latest back-up and this worked.

Thanks,
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
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…

715 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