invalid name in update query

[Guest]

In redesigning an update query in Access 2003 that I have used before
(updating one table based on info in another), I suddenly get a message that
the name of the query is invalid, though it is a valid name. What's up?

 

[Jeff Boyce]

Given that Access believes the query name is invalid, do you really want to
argue? <g!>

What happens if you change the query name?

What happens if you change the query name "back" to what should work?

 

[Guest]

Yup. Changed it back to the original name and tried several others. All
innocent short words with no special symbols. Still gives me the error
message no matter what.

 

[Dale Fye]

What is the offending name?

Yup. Changed it back to the original name and tried several others. All
innocent short words with no special symbols. Still gives me the error
message no matter what.

 

[Jeff Boyce]

So, it sounds like no matter what you call it, it fails. Have you created a
totally new query, with a totally new name? I've had queries get subtly
corrupted and had to throw them away and start over.

 

[Guest]

Hello ALL:

I have the same situation. Name is invalid, can't find, or too long.
My name has been cut down to:
qry01ExecOverallMakeTbl

from:
qry01ExecScorecardOverall_MakeTbl

and is still invalid. The queries, whichever name I used, do run on
doubleclicking.
Is there a name length limitation for OpenQuery?

My code:
Case 5 'run a particular Query
DoCmd.SetWarnings False 'this query is a MakeTable
sbarStatus.SimpleText = "Processing Query: " & strQuery
Me.Repaint
DoCmd.OpenQuery strQuery 'get the ERROR from this line
DoCmd.Hourglass False
DoCmd.SetWarnings True

Halp.

MichaelM

 

[Guest]

Replying to MeSelf:

I found my particular problem. I had a reference in the query Criteria back
to my form and field. The syntax wasn't quite right and it looked like one
giant field -and-, therefore, a name that did not exist as a field.

One I fixed the Criteria syntax it ran, even when I put my larger queryname
back on.

MichaelM