S
S Davis
Hi gang,
I have a lengthy set of queries which I run through a Macro, and
rather than eat up all my time at work, I'd rather set this to
automatically run later at night while I'm away from the office and
the servers are free.
I know that you can create a macro called Autoexec which will run
automatically when the database is opened. However, my database is
password protected (it hits our payroll system) - I have thought about
using scheduled tasks to just open the database every day and have the
autoexec macro execute, but the database password gets in the way and
sits waiting for my prompt.
Is there anyway to include the password when this scheduled task
opens? I know you can use various DOS toggles (-f, -t, etc) off of the
filename, but I'm unsure if this would be the way to go (if it is the
way to go, I wouldn't know which one to use anyway)... or if there is
a better way to run these queries automatically every day while I am
out of the office.
Any tips or advice? Thanks!
I have a lengthy set of queries which I run through a Macro, and
rather than eat up all my time at work, I'd rather set this to
automatically run later at night while I'm away from the office and
the servers are free.
I know that you can create a macro called Autoexec which will run
automatically when the database is opened. However, my database is
password protected (it hits our payroll system) - I have thought about
using scheduled tasks to just open the database every day and have the
autoexec macro execute, but the database password gets in the way and
sits waiting for my prompt.
Is there anyway to include the password when this scheduled task
opens? I know you can use various DOS toggles (-f, -t, etc) off of the
filename, but I'm unsure if this would be the way to go (if it is the
way to go, I wouldn't know which one to use anyway)... or if there is
a better way to run these queries automatically every day while I am
out of the office.
Any tips or advice? Thanks!