Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Break an Auto Exec Macro

Posted on 2006-07-20
3
Medium Priority
?
485 Views
Last Modified: 2012-06-21
I just did something stupid, I wrote an Auto Exec Macro that runs a macro and then quits Access.  Now I can’t break the macro to edit the database.  I tried to Ctrl_Break but it didn’t stop it.  Lucky thing I have a back up  before I wrote this.  How do I stop the macro from running?

Any help would greatly be appreciated!!
0
Comment
Question by:ca1358
  • 2
3 Comments
 
LVL 66

Accepted Solution

by:
Jim Horn earned 2000 total points
ID: 17147610
>How do I stop the macro from running?
Hold your SHIFT button down when you open your Access app.  This will bypass AutoExec macros and Startup objects.
Then you can edit-delete your AutoExec macro.
0
 

Author Comment

by:ca1358
ID: 17147701
Thank you!
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 17147800
Thanks for the grade.  Good luck with your project.  -Jim
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

773 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