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

On Wed, 9 Jan 2008 15:44:35 -0800, PcolaITGuy
<(E-Mail Removed)> wrote:

>2. Once all macro operations are completed, automatically close the DB and
>the Access program.
>

Just put

Quit

in the action of the last step of the macro.

John W. Vinson [MVP]

=?Utf-8?B?UGNvbGFJVEd1eQ==?= <(E-Mail Removed)>
wrote in news:8367D4D8-B3BE-40B9-A12D-(E-Mail Removed):

> 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
>
Create a new macro, that has 2 steps: the first is RunMacro with
your existing macro as the macro to run, and the second step
executes the Quit action. Save your macro as My_Macro_CloseDb.

Change the /x parameter to the name of the new macro

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com