?
Solved

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

Posted on 2011-02-22
6
Medium Priority
?
944 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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 2000 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

864 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