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
|
|||
|
|||
Query won't for editing in design view in 2007
I have a query that will not open for editing in Access 2007 design view.
There is an error message that comes up that states the following: " is not a valid name. Make sure it does not contain invalid characters or punctuation and that it is not too long. I need to edit the query but can not find a way to open it to edit. The query is in a database that was converted from 2003 to 2007, however, if I open the 2003 database version in 2007 without converting I still have the same problem. When run the query functions correctly without any errors. I just can't edit it which is a problem. This seems to be a bug in Access 2007. Anyone know how to resolve it? |
#2
|
|||
|
|||
Query won't for editing in design view in 2007
Neil wrote:
I have a query that will not open for editing in Access 2007 design view. There is an error message that comes up that states the following: " is not a valid name. Make sure it does not contain invalid characters or punctuation and that it is not too long. I need to edit the query but can not find a way to open it to edit. The query is in a database that was converted from 2003 to 2007, however, if I open the 2003 database version in 2007 without converting I still have the same problem. When run the query functions correctly without any errors. I just can't edit it which is a problem. This seems to be a bug in Access 2007. Anyone know how to resolve it? -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 You can read the SQL of the query like this (in the Debug window [Ctrl G]): ? CurrentDb.QueryDefs("query_name").SQL The above will print out the SQL of the query. You can put a new SQL statement in the query like this: CurrentDB.QueryDefs("query_name").SQL = "SELECT * FROM tableName" It would probably be best to read the SQL from the affected query and create a new query with that SQL string - then delete the old query. -- MGFoster:::mgf00 at earthlink decimal-point net Oakland, CA (USA) ** Respond only to this newsgroup. I DO NOT respond to emails ** -----BEGIN PGP SIGNATURE----- Version: PGP for Personal Privacy 5.0 Charset: noconv iQA/AwUBSZJBgYechKqOuFEgEQICLgCZAUl74OK9DRpK3FWXm+R4JE ojtP4AnjLM gj5np5bpZ4Jg52Y4t7LhpMrf =eJu6 -----END PGP SIGNATURE----- |
Thread Tools | |
Display Modes | |
|
|