Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2011-02-22
6
Medium Priority
?
939 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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

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.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

636 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