Microsoft KB Archive/259873

= ACC2000: &quot;No Current Record&quot; Error with Linked ODBC Tables =

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:

No Current Record

In some cases you also receive the following error message

ODBC Call Failed

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.