Results 1 to 2 of 2
  1. #1
    HawkGuru is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    11

    Unhappy AutoExec Mistake

    I was attempting to set up an AutoExec Macro that will display a MsgBox which would automatically enable the content of the database when clicking OK. The first line of my macro action is set to SetDisplayedCategories in Tables and Related Views. I set the second line's action to MsgBox. Then I mistakenly set the third line with a condition of Not[CurrentProject].[IsTrusted] and the action to Quit. Now whenever I open the database, the message box is displayed. As soon as I click OK in the message box, the database quits since the content has not yet been enabled. I cannot modify anything in order to remove the AutoExec macro. Is there any way to backdoor the database so i can get back into it to remove my error? If not, my database is lost.

  2. #2
    HawkGuru is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    11
    I went into the Trust Center and enabled all macros temporarily. That allowed the database to not quit since everything was trusted. Then I was able to remove my error and set it up correctly. Now it functions just as I wanted.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Out of control loop in autoexec macro
    By accessnewbie in forum Programming
    Replies: 2
    Last Post: 08-19-2010, 04:31 PM
  2. Using parameter in autoexec macro
    By lchurch in forum Queries
    Replies: 0
    Last Post: 03-04-2009, 06:22 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums