If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"is not a valid name. Make sure...
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. |
#2
|
|||
|
|||
"is not a valid name. Make sure...
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. "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. |
#3
|
|||
|
|||
"is not a valid name. Make sure...
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 |
#4
|
|||
|
|||
"is not a valid name. Make sure...
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. "KARL DEWEY" wrote: 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. "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. |
#5
|
|||
|
|||
"is not a valid name. Make sure...
Hi Ron,
I posted a response to both your and Karl's reply on the discussion boards. Really appreciate the help! Thanks, -- AndrewB. "Ron2006" wrote: 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 |
#6
|
|||
|
|||
"is not a valid name. Make sure...
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. |
Thread Tools | |
Display Modes | |
|
|