how kill query?

  • Thread starter Thread starter mykalc
  • Start date Start date
M

mykalc

Hi,

I kicked off an Access query that takes about 10 minutes to run - is
there any way to kill the query without actually closing the whole
database?

tia,

myk
 
You can use CTRL + BREAK but you need to be careful when stopping a query
that is something other than just a simple SELECT. If it is an
update/insert/delete statement, you may leave your tables in an undesirable
state.

HTH,
LT
 
That's a great question... I've only been to Montana; seemed fine to me. But
I wouldn't know better anyways since I'm Canadian.
 

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

Youtube is a problem 6
Queries & table locking 4
Query slow after being renamed 1
Make-table query with around 2 ml records taking too long 0
Query on SQL Server is fast, while Access is crawling 2
Make a tbl qry (union) running very very slow 3
Slow Query? 5
Question about query optimization 3

Back
Top