Could not find object Error 3011: Need Advice

[Elysynn]

Hello,

I am currently trying to run a query (qrySB-Summary) and when I double click on the query, I get the following message: Microsoft Jet could not find the object "qrySB-Summary"... The query is there. I just clicked on it! All of the queries that feed qrySB-Summary work - so the problem isn't with the tables. This has happened randomly with a few other queries in this database. I tried deleting the existing query and rebuilding it using the same name, all to no avail. I'm really very confused about why this suddenly stopped working. Any ideas you might have on the cause of the problem or recommendations for resolving the problem would be greatly appreciated.

Thanks much,
Elysynn

 

[jsteph]

What version of Access? 2000 by chance?
There were some severe corruption issues w/A2000 where you'd get this.
--Jim

 

[Elysynn]

Sorry, I suppose that might have been a useful bit of info. It is indeed Access 2000.

-Elysynn