ACC2000: "No Current Record" Error with Linked ODBC Tables

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.

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.

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:

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.