No current record. (Error 3021)

[Guest]

I have an access 2000 database. When I run the compact and repair wizard from the tool bar, I get
the "no current record" error.
This error seems to indicate that a table is empty or something. This is not the case. All my
tables do have data in them. Any ideas, anyone?

 

[Joel Fleischman]

If you have a start-up form there may be something wrong
in this form

-----Original Message-----
I have an access 2000 database. When I run the compact

and repair wizard from the tool bar, I get

the "no current record" error.
This error seems to indicate that a table is empty or

something. This is not the case. All my

 

[Allen Browne]

Firstly check if you have the latest version of the Jet 4 serice pack.
Locate msjet40.dll (usually in windows\system32), right-click, and choose
Properties. If the Version tab shows less than 4.0.8015, download the latest
from support.microsoft.com, under Service Packs. This article lists at least
one case where that message was addressed in the service pack:
http://support.microsoft.com/?id=259873

If that does not solve the problem, you could try rebuilding the mdb in case
it is corrupted. Details:
http://allenbrowne.com/ser-47.html