<

[Error Solved] The Microsoft Jet Database Engine Stopped the Process

Published on
942 Points
942 Views
Last Modified:
Bharat Bhushan
Experts in data recovery from corrupt Exchange mailboxes, SQL database, and Outlook emails.
“The Microsoft Jet Database engine stopped the process…” while working with a Microsoft Access database. The database may be saved as MDB or ACCDB file depending on the Access version that you used to create the database file.

As a technology professional, you are possibly here to find out the solution for fixing the error:
“The Microsoft Jet Database engine stopped the process…” while working with a Microsoft Access database. The database may be saved as MDB and ACCDB file depending on the Access version that you used to create the database file.


All about the Access database error


What is the error?


The complete error message is The Microsoft Jet Database engine stopped the process because you and another user are attempting to change the same data at the same time.


Why the error occurs?

 

The cause for the occurrence of this error is the Jet Database Engine cannot correctly read the ‘long value page’ from the pointer that is present in the data row. This error generally, but not always, signifies corruption in the Access database MDB or ACCDB file, thereby making the files inaccessible.


Solutions


Follow the methods explained below until your Access database file becomes repaired and you stop receiving the ‘Jet Database Engine Stopped’ or ‘Microsoft Jet Database Engine Stopped’ error while working with the Access database saved as ACCDB or MDB file. It is also essential to be aware that the capability of each of the methods depends on type and level of corruption. The methods that you can attempt are as follows:


  • Use ‘Compact and Repair Database’ – It is an inbuilt utility in MS Access application that can repair the damaged Access database MDB and ACCDB file. If you have Access 2013, Open Access, click ‘DATABASE TOOLS’ menu, click ‘Compact and Repair Database’to select and subsequently repair the damaged Access database file. For other versions of MS Access, the steps are similar.


  • Restore the Access database from a previously created backup – If you have a backup copy of the Access database, you can try restoring it to recover the stored data that became inaccessible because of corruption in the database MDB or ACCDB file, as the case may be. Nonetheless, this method is possible only if you have a previously created backup file.


  • Import all data into a new Access database file - Create a new database in MS Access application. Next, import all the data such as tables, forms, reports, queries, macros, data access pages, modules and other objects in the newly created database file from the damaged database file.


  • Decompile the Compiled VBA Code – You can try fixing the error by removing the existing VBA codes from the Access database.


  • Use a professional ‘Access database file repair’ tool – A good deal of third-party software to repair damaged Access database MDB and ACCDB files. You can use one to check if the error gets fixed. Stellar Phoenix Access Database Repair is a professional tool known for repairing the Access database files efficiently and successfully. Recovery of deleted records in addition to other objects is an advantage. Plus, it can be commonly used for all Access database versions including Access 2016.


  • Open the Access database file in another environment – Try to open the Access database file on different local systems, especially if you are working with a database on a system that is connected to the network. If the database file opens, file corruption may not be the reason for the error to occur.


Conclusion

MS Access database files are vulnerable to corruption issues. Therefore, on encountering ‘Jet Database Engine Stopped’ error while working on an Access database MDB and ACCDB file, you can try to fix it by: using the inbuilt ‘Compact and Repair Database’ utility, restoring the backup of Access database, moving all database objects into a newly created Access database, decompiling the compiled VBA code with a specific command all of which can be categorized as the manual ways, or using professional Access database file repair software that can be placed in the category of an automated method.


However, if you prefer to pick a quick, effective, secure and user-friendly solution, avoid the manual methods and use a software solution instead. You can fix several other errors, such as ‘Unexpected error 35012’, ‘Unrecognized database format’, ‘The VBA project in this database is corrupt’, etc. using the solutions explained in this article.


 

0
Ask questions about what you read
If you have a question about something within an article, you can receive help directly from the article author. Experts Exchange article authors are available to answer questions and further the discussion.
Get 7 days free