Solved

Opening Access 2013 Database error

Posted on 2016-11-11
7
37 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

790 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