How stop a query in Access 2007

V

vtj

In previous versions of Access, pressing Ctrl-Break would stop a query in
progress. This no longer works in Access 2007. Is there a new command to
stop a query started in error that could run for a very long time without
forcing Access to end?
 
R

Rick Brandt

vtj said:
In previous versions of Access, pressing Ctrl-Break would stop a
query in progress. This no longer works in Access 2007. Is there a
new command to stop a query started in error that could run for a
very long time without forcing Access to end?
Click to expand...

Are you using a server back end like SQL Server? It has never been possible
to halt a running query with Ctl-Break against a server back end. If you
are using a standard MDB/AccDB file for your tables then as far as I know it
should work. Certainly wouldn't surprise me if the behavior was changed
though in 2007.
 
V

vtj

Thank you for your fast and complete response!!!

Rick Brandt said:
Are you using a server back end like SQL Server? It has never been possible
to halt a running query with Ctl-Break against a server back end. If you
are using a standard MDB/AccDB file for your tables then as far as I know it
should work. Certainly wouldn't surprise me if the behavior was changed
though in 2007.
Click to expand...
 

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

Arrange tabs in Access 2007 1
Exporting Query from Access 2007 to Excel 2007 4
Debugging does not work - Access 2007 1
How do I create a desktop shortcut for an Access 2007 query 2
MDE problem in Access 2007 12
Report Query Works 2nd Time, But Not 1st 14
Access Query problem 1
Parameter Value error in a Subform 0

Top