"is not a valid name. Make sure...

[AndrewBerry]

I just started getting the error message: "is not a valid name. Make
sure that it does not include invalid characters or punctuation and
that it is not too long."

I did not get this message 'yesterday'. Does anyone know what is
going on? I only get the message when trying to open a query in
Design View when the query is querying more than 1 table or query. No
error message on queries that contain only 1 table. I can open them
in Design View fine.

I even experimented by creating a table called Table1 and Table2, each
with 1 field [Test1] and [Test2]. I pulled Table1.Test1 into a new
query saved, closed, and can open the query in Design View fine. As
soon as I pull in Table2, save and close then try to open Query1 in
Design View I get the error message above.

I have no special characters like: # _ , ' & anywhere in the new empty
2007 version Access Database (only the 2 tables and the 1 query) for
testing purposes. The database name is Database1 and no special
characters in the path to the file on my C: drive.


Any suggestions what is wrong or what the fix is?

 

[GBA]

* designate a key field in each table - add an autonumber field and make it a
key field if you need to
* when you have multiple tables together in a query design - be sure two
fields join with a relationship line joining them together & and be sure the
two joined fields are the same data type (number-number or text-text)