Error message "Object Invalid or no longer set" with SP3

[john.goos]

I am getting the error message "object invalid or no
longer set" when working in a set of converted Access 97
databases. This only happens with Access 2000 with SP3. It
does not happen with Access 2000 with SR1. Anyone have
the "cure"?

John Goos @ LMCO

 

[Naresh Nichani MVP]

Hi:

There should be no issues in Access 2000 SP3. This error occurs if variable
is out of scope or is set to Nothing or was never set.

Check the scope of the variable or post the code where it occurs so someone
can take a quick look.

Regards,

Naresh Nichani
Microsoft Access MVP