Solved

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

Posted on 2011-02-22
6
922 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
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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

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-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Documents and settings folder 30 78
User Level Security 6 38
Should I keep recordsets open? 3 24
SetFocus doesn't wait for input 14 34
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

777 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