Delaying the execution of a macro

D

Daniel P

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
 
N

Newbie

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top