Re: Design View

Can we assume that you put your database is a "trusted" location? If not,
you may have some security problems, where the code won't run.

If that is not the issue, it sounds like it could be time to get Access to
recreate the database for you. Create a new (blank) database, and import
everything from the Access 2000 database.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"BBran" <bbran@xxxxxxxxxx> wrote in message
news:eYBWIL1BHHA.4292@xxxxxxxxxxxxxxxxxxxxxxx
OK, I tried your suggestions (they will open in SQL view and run fine).
However, when I switch to Design view I get the same error again. The
queries do run fine, they just won't open in design view.


"BBran" <bbran@xxxxxxxxxx> wrote in message
news:%23EC%23ysaBHHA.204@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for the reply. I'll get to this next week and report back.


"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
news:%23RnALxTBHHA.2140@xxxxxxxxxxxxxxxxxxxxxxx
Okay, the quotes at the beginning indicate that Access 2007 is confused
about the name of something.

Suggested sequence:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair

3. Try the query again.

4. If it still fails at this point, open the Immediate Window (Ctrl+G), and
enter:
? CurrentDb.QueryDefs("Query1").SQL
substituting your query name for Query1.
When you press Enter, it should print the SQL statement of the query into
the Immediate Window. Copy this to clipboard.

5. Create a new query (no tables.)
Switch it to SQL View (View menu.)
Paste in the SQL statement.
Fix any line endings (e.g. the Immediate window gave you multiple lines that
broke in the middle of a field name.)

6. Test.

7. If it still fails, paste the SQL statement in a reply to this thread.

If you still have Access 2000 on your computer, at step 4 above you could
open the query in Access 2000, switch to SQL View (view menu), copy to
clipboard (Ctrl+C), switch to Access 20007, and paste the query statement
there.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"BBran" <bbran@xxxxxxxxxx> wrote in message
news:OnHkbWOBHHA.2304@xxxxxxxxxxxxxxxxxxxxxxx
Hello Allen,

I was thinking maybe there was some general reason why a query wouldn't open
in design view in Access 2007 B2TR when it would in Access 2000. Sorry for
the oversight.

The exact 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 to see what the problem is.

--

Respectfully,
Bob Brannon


"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
news:%232ewO1JBHHA.992@xxxxxxxxxxxxxxxxxxxxxxx
Someone might have a suggestion, Bob, if you could tell us what the error
message says.

"BBran" <bbran@xxxxxxxxxx> wrote in message
news:%23j3mEHEBHHA.3396@xxxxxxxxxxxxxxxxxxxxxxx
Hello,

I am using Access 2007 B2T2. I am trying to open a query in design view but
get an error. The same query opens fine in design view in Access 2000.

Any suggestions on how to get it open in 2007?



.

Relevant Pages

  • Re: Design View
    ... Okay, Bob, the query contains the reserved word DATE as a field name. ... new database has a problem with references. ... you may be able to get the SQL statement in A2007 opening the ... The same query opens fine in design view in Access 2000. ...
    (microsoft.public.access.queries)
  • Re: Design View
    ... the new database has a problem with references. ... Putting all that together, create a new query, cancel the Add Table ... you may be able to get the SQL statement in A2007 opening ... The same query opens fine in design view in Access 2000. ...
    (microsoft.public.access.queries)
  • Re: Word 2000 and Email Merge in HTML Format
    ... Yes button on behalf of you, when Outlook's Security Guard opens prompt ... I have an Access 2000 Database with a query that runs and gets Customer ... The Email needs to be sent in HTML Format. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: ADO data control
    ... Another way to test your query would be to try ... instinctively think that the database is probably not normalized. ... written on the topic of normalization, and one you might like is "Database ... Then the SQL statement and the existing WHERE and ORDER BY calculations ...
    (microsoft.public.vb.controls)
  • Re: Design View
    ... Someone else may be able to provide a suggestion. ... I also checked references and they seemed fine for that database, ... Okay, Bob, the query contains the reserved word DATE as a field name. ... you may be able to get the SQL statement in A2007 opening the ...
    (microsoft.public.access.queries)
Quantcast