Delaying the execution of a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I've created (with many of your hint and ideas) a macro that backs up my database. This macro is part of a dummy access database (no content just this autoexec macro). I've place the database in my startup menu so that it launches everyday when I log on. Thus, making a daily backup

My question is as follows. When I bootup my computer a "script" has to run which maps my drive and give me my permissions.... Currently, both the script and the macro database are launched simultaneously and the macro can't locate the server because I still don't have it maped or don't have the required permission. Is there a way to delay the macro from executing for 30 seconds or so? Or is there a better way of attaining my goal

Thank you as always

Daniel
 
could you put a DO Events between the line of code that launches the script
and the macro?
Daniel P said:
Hello,

I've created (with many of your hint and ideas) a macro that backs up my
database. This macro is part of a dummy access database (no content just
this autoexec macro). I've place the database in my startup menu so that it
launches everyday when I log on. Thus, making a daily backup.
My question is as follows. When I bootup my computer a "script" has to
run which maps my drive and give me my permissions.... Currently, both the
script and the macro database are launched simultaneously and the macro
can't locate the server because I still don't have it maped or don't have
the required permission. Is there a way to delay the macro from executing
for 30 seconds or so? Or is there a better way of attaining my goal?
 
Back
Top