Jump to content
Macro Express Forums

Scheduled Macro Runs Twice


Teessider66
 Share

Recommended Posts

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

Link to comment
Share on other sites

Looks good, nothing jumps out at me. Since this is a pretty simple macro, maybe you should just delete it and create a new one?

 

The only modification I suggest, just for kicks, is to build in some delay - say five seconds. Grasping here but maybe Access is sending back an odd event code.

 

Macro code ....

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

 

Here is a 5 second delay -

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...