Home All Groups Group Topic Archive Search About

script to shutdown MS access



Author
23 Nov 2007 11:06 PM
OM
Hi,

Can anyone tell me how to use a script to shutdown MS access in a
graceful way?

Thanks

Keith

Author
27 Nov 2007 9:39 PM
Jeff C
Using a command line switch to run a macro in a particular database can
sometime be very convenient.

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\full path to
your\*.mdb" /x "name of your macro"

You could use the command line above, paste into notebook but save a a batch
file.

Create a macro in the database you wish to shut down using the Quit command
in the macro.

Wherever the database is the batch file will then close it.  If you want
schedule the batch file using the task scheduler.
--
Jeff C
Live Well .. Be Happy In All You Do


Show quote
"OM" wrote:

> Hi,
>
> Can anyone tell me how to use a script to shutdown MS access in a
> graceful way?
>
> Thanks
>
> Keith
>

AddThis Social Bookmark Button