query error message - Jet database Engine

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark1 - 28 Feb 2007 21:17 GMT

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?

Reply to this Message

Jerry Whittle - 28 Feb 2007 21:31 GMT

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

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> The name of the query that I am trying to run is called
> "qryRegionalAdmitSummary_Mark". The error message that I get says:
[quoted text clipped - 5 lines]
> the error message as an invalid field or expression? The query doesn't call
> itself! Can anybody tell me why this might happen?

Reply to this Message