Solved

Control-Break won't stop execution in my Access 2007 application

Posted on 2011-02-22
6
926 Views
Last Modified: 2012-05-11
I recently converted an application from Access 97 to Access 2007.  When I come in in the morning, my application is still running, and and control-break won't stop it.  So I have to use the task manager to stop it, and I can't see what code it was stuck on.

How can I get the code to pause and show me what line it's executing?
0
Comment
Question by:Barry Sweezey
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 6

Expert Comment

by:Darren Sharples
ID: 34953607
Go to start up options and make sure you have a tick in "Use access special keys"
0
 

Author Comment

by:Barry Sweezey
ID: 34954025
It was already selected.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34954100
in A2007
office button > access options > current database > application options
place a check on "Use Access special keys"
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:Barry Sweezey
ID: 34955154
Yep, already selected.
0
 

Author Comment

by:Barry Sweezey
ID: 34962401
I tried control-break while this application was doing something else and it worked.  But I came in and tried it again this morning and it didn't.  Might it be that maybe it'll stop if it's executing code, but not if it's running a query or something?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 34964432
Usually Access will display a message like:
    "Executing... Press Ctrl-Break to cancel"
...In this case, yes, ...pressing Ctrl-Break will cancel it.

If, on the other hand, you are just running a complex query, then this may not work.

Remember that if ctrl-break does not work, then you may want to just wait instead of using Task manager.

Task manager will "Crash" you out of Access, and may leave your DB in an unstable state at best, or at worse, corrupt the DB.

As always, make regular backups and run the Compact/Repair utility often/regularly.


JeffCoachman
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question