Jump to content
Macro Express Forums

Teessider66

Members
 View Profile  See their activity

  • Posts

    2

  • Joined

  • Last visited

 Content Type 

Posts posted by Teessider66

  1. Scheduled Macro Runs Twice

    in Macro Express 3.x

    Posted

    Is this what you mean?

     

    Macro code ....

    <LAUNCHDEL2:0:00C:\db1.mdb>

     

    MS Access Code ....

     

    DoCmd.SetWarnings False

    DoCmd.RunSQL ("INSERT INTO Table1 ( Events ) SELECT Now() AS Expr1;")

    DoCmd.Quit

     

    This is just to test the repeated triggering of an Access database.

    I'm on XP SP2, MS Access 2000

  2. Scheduled Macro Runs Twice

    in Macro Express 3.x

    Posted

    I have scheduled a macro to run each at at 06:00. The sole purpose is to open an Access database, which updates some tables and then shuts itself down.

     

    The macro simply opens the database. It runs fine, dead on 06:00, but then opens the database again about 5 seconds later, and I get an error #29.

     

    Why is it running twice and why the error?

     

    I am using 3.5.5.1, 3.5e Build 1

×
×
  • Create New...