How to start Microsoft backup from Access 2000 and Access 2002 (302502)


The information in this article applies to:

  • Microsoft Access 2002, when used with:
    • the operating system: Microsoft Windows 98
    • the operating system: Microsoft Windows 98 Second Edition
    • the operating system: Microsoft Windows Millennium Edition
  • Microsoft Access 2000, when used with:
    • the operating system: Microsoft Windows 98
    • the operating system: Microsoft Windows 98 Second Edition
    • the operating system: Microsoft Windows Millennium Edition
This article was previously published under Q302502
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SUMMARY

In Access and other Microsoft Office applications, you can use the Shell function in Visual Basic for Applications (VBA) code to start another application. Although you can start most applications in this manner, there are some applications that the Shell function does not support. Microsoft Backup is one of these applications.

MORE INFORMATION

By using the Shell function, you can start an MS-DOS batch file that, in turn, calls MSBackup.exe.

NOTE: MSBackup.exe is available only on the Microsoft Windows 95, the Microsoft Windows 98, and the Microsoft Windows Millennium operating systems. You may have to install Microsoft Backup from your CD if MSBackup.exe is not located in your \Program Files\Accessories\Backup folder.

To start Microsoft Backup from Access, follow these steps:
  1. Click Start, point to Programs, point to Accessories, and then click Notepad.
  2. Type or paste the following code in the Notepad document:
    CD \ 
CD \"Program Files"
CD \"Program Files\Accessories\Backup"
MSbackup.exe
  3. Save the text file in the root directory of drive C with the name LaunchMSBackup.bat.
  4. Create a command button on a form, and then create the following code for the Click event of the command button:
    Dim x
x = Shell("C:\LaunchMSBackup.bat")
  5. Click the command button to run the .bat file, and then close the MS-DOS window that is used by the Shell command.
Modification Type:MajorLast Reviewed:10/7/2004
Keywords:KbVBA kbhowto KB302502
©2004 Microsoft Corporation. All rights reserved.