This article was previously published under Q318882
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
If you add a record to a Microsoft SQL Server-linked table and then try to delete that record, you may receive the following error message:
The Microsoft Jet database engine stopped the process because you andanother user are attempting to change the same data at the same time.
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.
To resolve this problem, do not allow Null values, or establish a default value on the fields with a bit data type. To do so, follow these steps:
NOTE: To perform this procedure, you must have the appropriate permissions to modify database objects (db_ddladmin or db_owner).
Start SQL Server Enterprise Manager, and then locate the server where the database is located.
Expand the Databases folder, double-click the database name, and then click Tables.
In the right pane of SQL Server Manager, right-click the table where the field with a bit data type is located, and then click Design Table.
Under Default Value, type either 0 (zero) or 1.
NOTE: To disallow Null values, clear the appropriate Allow Nulls check box.