?
Solved

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

Posted on 2011-02-22
6
Medium Priority
?
934 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
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 …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

752 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