Solved

Opening Access 2013 Database error

Posted on 2016-11-11
7
29 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
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

746 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

12 Experts available now in Live!

Get 1:1 Help Now