Opening a query in SQL View

J

Jim Pockmire

Is it possible to open a query in SQL view without first opening it in
design view? Opening in design view breaks links to non-existing tables and
sometimes MS-Access seems to automatically save the query with the broken
links, without prompting to cancel.
 
M

Marshall Barton

Jim said:
Is it possible to open a query in SQL view without first opening it in
design view? Opening in design view breaks links to non-existing tables and
sometimes MS-Access seems to automatically save the query with the broken
links, without prompting to cancel.
Click to expand...


Try saving the query from SQL view. It should then open in
SQL view.
 

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

EDIT SQL without going into design view first? 2
How do I open an Access 2003 query directly in SQL View? 3
Help viewing SQL of a query w/ a syntax error 2
Opening queries in design view when tables are not in the mdb 8
How to Restrict Users to view/go to Query Design/Sql mode in MDE/M 4
Cannot see fields in query design view on laptop; Access 2003 1
query links to SQL server and mdb table 1
Access Query error locks design view 1

Top