how to execute only selected query like SQL Server Query Analyzer.

G

Guest

in Sql Server Query analyzer i can execute only one selected query if there are
many queries are written on the pane for the current session.
I want the same thing on MS Access but i found that it always run all the
queries
written on the current pane.

arif.
 
D

Duane Hookom

I didn't know you an Access query could contain multiple separate queries.
Even if you could have multiple SQL statements in Access, you would not be
able to run them separately without copy and paste to an from notepad or
something.
 
G

Guest

Thanks Duane,

This is what i want to confirm. In SQL Server query analyzer this is great
feature so that i can test any sub-query by only selecting it from the whole
query written.
I like Access2000 and I was expecting this feature in it.

Arif.
 

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

Query on SQL Server is fast, while Access is crawling 2
query links to SQL server and mdb table 1
stored procedure query 4
Access 2000 Query very slow compared to SQL Query Analyzer 5
SQL query 1
Access 2010 append query to SQL is very slow 0
SQL Server batch in pass-through returns no records 5
SQL Select Query Prompting for NonExistent Parameter 8

Top