[wilsoncrosby]

I have a database in mdb format that will not open. When I try to open the file I get an error:
"The Microsoft Access database engine stopped the process because you and another user are attempting to change data at the same time"

I was the only user accessing the database and this occurred after a compact/repair.

Any ideas on how to get the db working again?

[Dang3r]

Did you store the base onto a synchronized server and your hard disk? Seems like a synchro error...if thats is it not: Another compiler session tested before use? Just to ensure that the base is comleted after last wrote in?

[harleywright]

Short guide can be helpful for you, if not see helpful topics are collected over Internet, if again they can't help you, then your corruption is complicated and needs to solve via more powerful solution https://www.openfiletool.com/mdbopen.html MDB Open File Tool

• Launch the Microsoft Access application, but do not try to open the corrupted MDB file.
• Go to "Tools" in the top menu bar, expand the "Database Utilities" submenu and select the "Compact and Repair Database" option if you are using Access 2002 or 2003. If you are using Access 2007 or 2010, you can find the "Compact and Repair Database" option by clicking the Microsoft Office button and going to the "Manage" menu.
• Highlight the MDB file that you want to restore and click the "Compact" button.
• Enter a name for a new database file, which will contain the restored data from the damaged MDB file.
• Navigate to the location on your hard drive where you want to save the restored version of the file.
• Click the "Save" button. Access will now compact and repair the MDB file and save a restored version in the location you selected.

[Riley2968]

Hi,wilsoncrosby

The mdb file format is very complex. It starts with a file header containing the meta information of the whole file, followed by several parts containing the actual data. You can find more detailed information about the mdb file format by searching on Google with the keyword “mdb file format”. If the file header containing the meta information is corrupt, or any follow-up parts are damaged or corrupted, then you will not be able to open the file correctly with MS Access. In such a case, the first step is to try to use the built-in repair or recovery function in the MS Access, to see if it can repair or recover the corrupt file. If not, then you need to resort to a third-party Access repair software to scan the corrupted file and retrieve all recoverable data for you. It is also possible to find a data recovery expert or company to do the task, but in most of the cases, they will also use a third-party tool to do the recovery for you.

First of all, you can try the build-in "Compact and Repair" command in Access to repair your corrupt database, you can get more detailed info at:

http://office.microsoft.com/en-us/ac...010341740.aspx
http://databases.about.com/od/tutori...3-Database.htm

If the above method does not work, then you can try third-party Access data recovery tools, such as DataNumen Access Repair at:

https://www.datanumen.com/access-repair/

I have used the tool in the past and it helps recovering some valuable data for me. The tool has a free demo so that you can try before you buy.

The main difference between using the software by yourself and by a third-party service company is:
(1) The company is familiar with the data recovery industry so he knows which software is the best one. While you need to search and compare the software online by yourself, which is time-consuming.
(2) The company purchases the software for multiple usages, while you purchase the software for one-time usage only. So normally the service fee may be cheaper than the license fee for the software.
(3) DIY will keep your data confidential while do the recovery via a company may cause data breach.


Hope that helps! Good luck!