Loading ...

How to Stop an Access Query

Updated February 21, 2017

In most cases, a well designed Microsoft Access query should take only a few seconds to return its data. Even if the database is a very large and complex one, getting the data you need from the query should take no more than a few minutes. If your query runs and runs and fails to return any data, chances are the query itself is problematic and will need to be changed. Before you can make those changes, you need to stop the query without closing the entire Access database.

Loading ...
  1. Place your cursor in the window containing the database. Look for the progress bar at the lower right hand corner of the screen.

  2. Allow the query to continue running if the progress bar appears to be moving. It could be that the query is simply taking longer than normal to run.

  3. Hold down the "Ctrl" key and press the "Pause/Break" key if you need to stop the query. This key combination will stop the query, and allow you to work with the database.

Loading ...

About the Author

Based in Pennsylvania, Bonnie Conrad has been working as a professional freelance writer since 2003. Her work can be seen on Credit Factor, Constant Content and a number of other websites. Conrad also works full-time as a computer technician and loves to write about a number of technician topics. She studied computer technology and business administration at Harrisburg Area Community College.

Loading ...