Query won't for editing in design view in 2007

[Neil]

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?

 

[MGFoster]

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+R4JEojtP4AnjLM
gj5np5bpZ4Jg52Y4t7LhpMrf
=eJu6
-----END PGP SIGNATURE-----