You are currently offline, waiting for your internet to reconnect

You receive "The Microsoft Jet database engine stopped the process" error message when you try to delete a record in Access 2000

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:
  1. NOTE: To perform this procedure, you must have the appropriate permissions to modify database objects (db_ddladmin or db_owner).

  2. Start SQL Server Enterprise Manager, and then locate the server where the database is located.
  3. Expand the Databases folder, double-click the database name, and then click Tables.
  4. 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.
  5. Under Default Value, type either 0 (zero) or 1.

    NOTE: To disallow Null values, clear the appropriate Allow Nulls check box.

Article ID: 318882 - Last Review: 01/09/2006 23:46:00 - Revision: 1.3

  • Microsoft Access 2000 Standard Edition
  • kberrmsg kbtshoot kbprb KB318882