Prev: Problem Passing Parameter from Form
Next: Query to find records after specific date and time today
From: Scott on 15 Mar 2010 15:13
Has there been any updates on this? I am getting this same error message on
2 databases that were converted to Access 2007.

Thanks,
Scott

"AndrewB" wrote:

> 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?
> --
> AndrewB.
 | 
Pages: 1
Prev: Problem Passing Parameter from Form
Next: Query to find records after specific date and time today