P
PcolaITGuy
I want to use task scheduler to open an Access DB, run a macro that updates a
table from an external source, then close the DB and Access. I do not use
any forms on this database, just one table and one macro.
So I guess my needs are as follows:
1. Automatically execute 'My_Macro' when the DB is opened from Task
Scheduler. My Scheduled Task uses the /X switch to specify and execute the
Macro - my main problem is determining how to programatically close the DB
and Access. I would like to continue using the command line method of
executing the macro if possible so that I can manually open the database
easily to do administrative tasks.
2. Once all macro operations are completed, automatically close the DB and
the Access program.
Your suggestions are greatly appreciated!!!!
Scott
table from an external source, then close the DB and Access. I do not use
any forms on this database, just one table and one macro.
So I guess my needs are as follows:
1. Automatically execute 'My_Macro' when the DB is opened from Task
Scheduler. My Scheduled Task uses the /X switch to specify and execute the
Macro - my main problem is determining how to programatically close the DB
and Access. I would like to continue using the command line method of
executing the macro if possible so that I can manually open the database
easily to do administrative tasks.
2. Once all macro operations are completed, automatically close the DB and
the Access program.
Your suggestions are greatly appreciated!!!!
Scott