Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

Moderate: Requires basic macro, coding, and interoperability skills.


This article applies only to a Microsoft Access database (.mdb).


↑ Back to the top

Symptoms

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.

↑ Back to the top

Cause

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.

↑ Back to the top

Resolution

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.

↑ Back to the top

Keywords: kbtshoot, kbsweptsoltax, kberrmsg, kbprb, kbsoconvert, ocsentirenet, kb, kbarchive

↑ Back to the top

Article Info
Article ID : 318882
Revision : 1
Created on : 1/7/2017
Published on : 1/9/2006
Exists online : False
Views : 330