By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,044 Members | 1,377 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,044 IT Pros & Developers. It's quick & easy.

Damaged mdb 2010 file gives strange error message

P: 1
A damaged MDB file gives this message when i try to open it:
"The Microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time."
The message is obviously wrong, no other user is attempting nothing.
I really want to repair this database as it contains customers data.
Please tell me if and how can i repair this file.
file Format - Access 2010.
Jun 23 '15 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
This indicates that someone has your file open.
Either the individual's PC has Access open as an active file or as a background process OR someone didn't close the file properly, this can happen when the sever drops the connection or if the user simply turns their PC off via a hard power down.

1) ABSOLUTLY make a backup of your file using either the OS and simply making a copy of the file to another location or via your favorite backup software.

2) Since you are in the directory where the database resides, you will find a file with the same name as your database with the extension "ldb" - read here before you do anything:
Introduction to .ldb files

3) Make sure everyone has Logged out of their accounts. Ideally they would actually power off their PC.

4) Now REBOOT the server/PC where the file resides. This ensures that no-one has the file open on their client. DO NOT ALLOW ANYONE TO OPEN THE DATABASE AT THIS POINT!

5) Rename the .ldb file:
From: yourdatabasename.ldb
to: old_yourdatabasename.ldb

6) Attempt to re-open your database.

6a) if you can open this database I highly advise that you move your database by the following steps:
- create a new, blank ACC2010 database.
- using the external data tool, open your old database for IMPORT and import all of the tables, queries, forms, reports, macros, and VBA modules into the new database.
- Save this database in the ACC2007/2010 format.

Keep in mind that as of ACC2013 any and all access files prior to ACC2003 are depreciated and will not be accessible starting with ACC2013 unless you use ACC2010 or OLDER.
Jun 23 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.