Article ID: 259873
Article Last Modified on 4/7/2006
APPLIES TO
- Microsoft Access 2000 Standard Edition
This article was previously published under Q259873
SYMPTOMS
When you use Microsoft Access 2000 to delete or update a record in a linked ODBC table, you receive the following message:
In some cases you also receive the following error message
followed by a vendor-specific error indicating that the update or delete failed. In either case, you cannot update or delete records.
CAUSE
In certain situations, Microsoft Jet 4.0 does not properly format the UPDATE or DELETE SQL command, which causes the ODBC driver to return a status code that indicates that no record was modified or deleted. Jet is too restrictive when it applies the Where clause, which results in no record being selected when using certain drivers.
RESOLUTION
To resolve this problem, install the latest Microsoft Jet 4.0 service pack. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
239114 How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Keywords: kberrmsg kbbug kbfix kbqfe kbhotfixserver KB259873