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

[AndrewB]

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?

 

[KARL DEWEY]

Post your query SQL by opening in design view, click on VIEW - SQL View,
highlight all, copy, and paste in a post.

 

[Ron2006]

Karl,

If Andrew is having the same problem that I have encountered, that is
part of the problem. I receive that message and then the design view
will NOT open so there is no way to get to the SQL view if you only
have Access 2007. I have been able to get around the problem in one
sence because I still have 2003 on some computers and therefore am
able to open the design view in 2003.

Searching through the groups has resulted in some saying that the
cause is predominantly the presence of an apostrophe in the name of
one or more of the directories. However I had one application/query
with the problem and when I checked it in 2003 I saw some extraneous
information stored in the orderby property. After I cleared that out
using 2003 I was able to examine the query in design view in 2007. (I
cannot remember right now whether that application had an apostrophe
in the path.) Either way it still indicates that there are potentially
more than one causes for the problem.

Ron

 

[AndrewB]

Hi Karl and Ron,

Thank you for your help

No apostrophes in my paths. I am even having the same problem with a new
2007 Access Database with only 3 objects in the db [Table1], [Table2], and
[Query1]. Below is the SQL for my query.

SELECT Table1.Test1, Table2.Test2
FROM Table1 INNER JOIN Table2 ON Table1.Test1=Table2.Test2;

Real simple query and I get the error message. If I pull out 1 table from
the qry I can go into design view, but not with 2 tables.

Also found out something else. I'm only having the problem at work on both
my PC's. I installed the MS Patch about a month ago that fixes the copy from
Excel Paste into an Access table issue generating the corrupted clipboard
error message. The patch fixed that. There could have been some kind of
software-push/update from my job which coupled with the MS Patch I installed
that could be causing the prob. Others in the office do not have this
problem - they did not install the Patch on their PC's.

Thanks,
--
AndrewB.

Post your query SQL by opening in design view, click on VIEW - SQL View,
highlight all, copy, and paste in a post.
--
Build a little, test a little.

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]

Hi Ron,

I posted a response to both your and Karl's reply on the discussion boards.
Really appreciate the help!

Thanks,

 

[Scott]

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