Access 2007 - Query Design View Error - " is not a valid name... - em

29-Oct-08 02:26:03
My database was built in 2003 and runs great in 2003, however, I get this
error when attempting to open a query in design view within Access 2007 (" is
not a valid name...).

I am running Office Professional Pro 2007 with SP1 on Win XP SP2.

All of my tables are linked to a backend Access DB on our network.
I generate this error attempting to view queries containing 2 or more tables.
I also generate this error attempting to view the Relationships window.

I have used proper naming conventions, no punctuation marks, etc. I am able
to open my tables in either view as well as run my queries or view them in
SQL. Also, I do not have security applied to this MDB.

Upon calling Microsoft, they apparently have listed this item as a bug (ref

Anyone hear of anything?

Thx!
reply
Access 2007 - Query Design View Error - " is not a valid name... - em 29-Oct-08
        RE: Access 2007 - Query Design View Error - " is not a valid name... - NT 29-Oct-08
                RE: Access 2007 - Query Design View Error - " is not a valid name. - Bronwy 29-Oct-08
                        RE: Access 2007 - Query Design View Error - " is not a valid name. - NT 30-Oct-08
                                RE: Access 2007 - Query Design View Error - " is not a valid name. - Bronwy 30-Oct-08
                                        RE: Access 2007 - Query Design View Error - " is not a valid name. - NT 30-Oct-08
                                                RE: Access 2007 - Query Design View Error - " is not a valid name. - em 03-Nov-08
                                                        RE: Access 2007 - Query Design View Error - " is not a valid name. - NT 03-Nov-08
                                                                RE: Access 2007 - Query Design View Error - " is not a valid name. - em 03-Nov-08
                                                                        RE: Access 2007 - Query Design View Error - " is not a valid name. - NT 03-Nov-08
                                                                                RE: Access 2007 - Query Design View Error - " is not a valid name. - em 03-Nov-08
                                RE: Access 2007 - Query Design View Error - " is not a valid name. - em 03-Nov-08
                RE: Access 2007 - Query Design View Error - " is not a valid name. - em 03-Nov-08
                RE: Access 2007 - Query Design View Error - " is not a valid name. - em 03-Nov-08
        Hi - Brendan 16-Jun-09
        thanks microsoft - Carolvm 26-Jun-09

Can't create append query
  

Search

search




Purchase