Shutting Access with a scheduled task

[dhstein]

Does anyone know what command to issue from a script, running as a scheduled
task, to force Access to exit (shutdown) on a user's system? This would
allow nightly backups. Thanks for any help on this.

 

[Albert D. Kallal]

Does anyone know what command to issue from a script, running as a
scheduled
task, to force Access to exit (shutdown) on a user's system? This would
allow nightly backups. Thanks for any help on this.

You don't want to "force" or "kill" the access application. Doing so can
damage that data file you are about to back up!

In other words, you want the application to gracefully shutdown.

yes, there is sample download, and I have successfully used it in several
applications.

a97
http://support.microsoft.com/default.aspx?scid=kb;en-us;128814

a2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;210297


The above can be set to shutdown the users application gracefully if they
not done anything, say for a 1, or perhaps 2 hours. The example does assume
your application is well behaved and you don't have silly things like asking
users to "save" a record they just worked on. So, if a user is stick at some
dialog box, then this approach will not work. However, is does work well for
the applications I used it on...