Click here to Skip to main content
14,580,589 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hello

I have a simple MS Access database. It stays in a local drive.
I have a simple Query named "usp_InsertBusiness" in this MS Access.
I tried to open this query using "Design View" to change this query, but an error message tells

"The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at same time."

It had been opened without this error, but someday it shows this error.
There is no other user attempting. This MS Access stays in a local drive.
It is only me to open this query.

How can I open this using "Design View"? How can I remove this error?

Thank you in advance.

What I have tried:

I copied it to other location and tried to open it.
Posted
Updated 1-Jun-20 5:17am
Comments
CHill60 1-Jun-20 10:28am
   
Have you tried using Tools, Compact & Repair? (Be sure to take a backup copy first)
Maciej Los 1-Jun-20 11:10am
   
Sounds like an answer!
Member 13194079 1-Jun-20 11:12am
   
It works. Thank you very much.

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Check this out: [Error Solved] The Microsoft Jet Database Engine Stopped the Process[^]

Quote:
...
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.
  • ...
   
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100