Queries won't open in Design View

B

Bob

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?
 

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

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Incone & Expenses Statement 0
Macro warning in word 1
Active Content in this file is blocked issue 1
query to show where no data in a stated column 0
Query won't open in design view 17
Opening Query in Design View 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0

Top