Problem in Access 2000

[Soumen]

I am having some problem with Microsoft Jet 4.0 SP 7.
Before this SP was installed, the code was working fine.
But after installation, some parts of the code give
errors. Now, in my machine, I can restore the system to
before this SP was installed, but one of my users is
having the same problems, and I am assuming that she has
a version of XP with Jet 4.0 SP 7 already installed, and
if such is the case, I can not uninstall the service pack
from her machine. The SP 7 does NOT come under Add/Remove
Programs.

Here's the code that is giving problems:
I have an MS Access application on Windows XP
Professional with some local tables and some linked
tables from a backend Sybase Database. A code snippet is
like the following:

With CurrentDB.OpenRecordset("SELECT <Fields> FROM
<Linked Sybase Table> WHERE <Condition>")
While Not .EOF
CurrentDB.Execute("Update <Local Table> Set
<Local Field>=" & .Fields("<FieldName>") & " WHERE
<Condition>")
.MoveNext
Wend
.Close
End With

The parts within < and > have actual values in the
original code.
This code is giving error on .MoveNext when SP 7 is
installed. The error is (Err.Description) "ODBC Call
Failed", and Errors collection has only one item
(Errors.Count=1), which is this error. I have checked and
found that if I don't have the update query within the
loop, MoveNext is working fine. Of course, the whole code
is working fine without SP 7.

This error is NOT because of the "With ... End With"
blocks. I have tried without With blocks, but had the
same error.