Access.2007.VBA.Bibl..

The final screen of the Task Scheduler Wizard displays a success message, shown in Figure 17.26.

FIGURE 17.26

The final success message indicating that a task has been scheduled.

Now the Daily Database Backup.vbs script will be run at 9 PM every day without user intervention.

When it is run, you will get several messages showing the name of the database to be copied, the

name of the copy of the database (shown in Figure 17.27), and a final message showing where the

copy was made. You will probably want to comment out these message boxes after verifying that

the script runs.

FIGURE 17.27

A message from a VBS script run from the Task Scheduler.

Creating Standalone Scripts with Windows Script Host 17