Queries won't open in Design View


G

Guest

Hello,

I am using Access 2007 Trial Version. I am trying to open queries in design
view but get an error. The same queries open fine in design view in Access
2000.

The exact error message is this (with quotes I added on either end):
"" is not a valid name. Make sure that it does not include invalid
characters or punctuation and that it is not too long."

Yes, the error begins with just a quotation mark. Of course I can't open
the query (except in SQL which I don't know) to see what the problem is. I
do not think it is specific to the queries though.

I discovered that this problem with viewing a query in Design View is
somehow related to showing more than one table or query in the design of that
query.

ANY query I have that is based on more than one query or table has this
problem. EVERY query I have based on only one table or query opens fine in
Design view. AND, ALL the seperate queries and tables that are comined in
another query open fine by themselves.

Does that provide any help to determine what the problem is?
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top