Not a Valid Alias Name

I

Iain

I have created a database that I run queries through a
macro on my own PC, when this is done the macro runs the
queries with no problems.

I am now wanting my colleague to run these queries but
when he clicks the macro he gets the error message "Not a
Valid Alias Name".

Obviously the 'names' are valid on my PC, why not his?

The name of the query that is causing the problem
is "qry__ABC data__003" - which gets it's data from a
union query.

Any help would be grateful.

Thanks Iain.
 
J

John Spencer (MVP)

Iain,

I don't know why it works on your PC and not his, but I would suspect that it
fails due to the space in the query name. Can you try renaming the query to
qry__ABC_Data__003
and see if your macro works?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"is not a valid name. Make sure 7
Crosstab with a filter 2
Union query is gone from access 2003 to 2007 1
Access 2007 query returning field names rather than alias 6
"is not a valid name. Make sure... 5
is not a valid name error with queries in Access 2007 1
Error message in queries, after upgrading from version 2003 to 200 1
Microsoft Jet Database engine does not recognise... 0

Top