Article ID: 318882 - View products that this article applies to.
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 and another 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: