Solved

Break an Auto Exec Macro

Posted on 2006-07-20
3
465 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 65

Accepted Solution

by:
Jim Horn earned 500 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 65

Expert Comment

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

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

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…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now