query error message - Jet database Engine

[Guest]

The name of the query that I am trying to run is called
"qryRegionalAdmitSummary_Mark". The error message that I get says:

"The Microsoft Jet database engine does not recognize
'qryRegionalAdmitSummary_Mark' as a valid field name or expression"

So, I don't understand how the name of the query I'm running can show up in
the error message as an invalid field or expression? The query doesn't call
itself! Can anybody tell me why this might happen?

 

[Guest]

Could be a corruption problem. Try going into SQL view and copy the SQL
statement. Next open a new query and past the SQL into it. See if that one
runs.

Below are some good resourses about Access corruption.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp