Not a Valid Alias Name

  • Thread starter Thread starter Iain
  • Start date Start date
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.
 
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?
 
Back
Top