Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Access database engine stopped the process because you and another user are attempting to change the same data

We recently Migrated an access database onto a SQL server. Upon completion we began testing the database using the front end access database we had (Our previous setup involved two access files, one for front end and one for back end.) We almost immediately received the error.

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

Now we do have multiple people working on these front ends but at the time of receiving this message, I'm the only person accessing the data. My general process for testing it has been to insert the data using the form. then attempt to delete the data. I know for a fact the data is making it to the table and I know for a fact I'm the only one viewing or attempting to edit this information we used an ODBC connection to attach SQL server to the front end. Any suggestions or help is greatly appreciated, I will be monitoring this thread heavily so Expect any questions you ask me to be answered relatively fast.

like image 381
ChettDM Avatar asked Mar 12 '13 16:03

ChettDM


People also ask

How do I fix Microsoft Jet database engine error?

Resolving The ProblemOpen Microsoft Access, but do not open a database. Cancel from the window prompting to open a database. Select Tools > Database Utilities > Compact and Repair Database. In Access 2007, select Microsoft Office Button > Manage > Manage this database > Compact and Repair Database.

How do I repair Microsoft Access database engine?

Open the Access application. Select the Database Tools tab. Then click the Compact and Repair Database option on the tab. A Database to Compact From window will then open from which you can select a database file to repair.

What is stellar repair for Access?

Stellar Repair for Access software fixes corrupt or damaged Microsoft Access files and saves the repaired database files to their default or a user-specified location. The tool seamlessly repairs corrupt MDB files as well as corrupt ACCDB files of the damaged MS Access database.


1 Answers

In this article, you will find that the error can be caused by the bit data type:

This problem occurs if fields with a bit data type in the SQL Server-based database have been left blank. Microsoft Access interprets blank fields as fields that contain Null values, and the Jet database engine does not release them. As a result, the records remain locked and are not available for deletion.

Note that you must always have a primary key or unique key to update data from SQL Server.

like image 83
Fionnuala Avatar answered Nov 16 '22 08:11

Fionnuala