|
server
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
script to shutdown MS access
Hi,
Can anyone tell me how to use a script to shutdown MS access in a graceful way? Thanks Keith 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. -- Show quoteJeff C Live Well .. Be Happy In All You Do "OM" wrote: > Hi, > > Can anyone tell me how to use a script to shutdown MS access in a > graceful way? > > Thanks > > Keith > |
|||||||||||||||||||||||