Microsoft KB Archive/302502

= How to start Microsoft backup from Access 2000 and Access 2002 =

Article ID: 302502

Article Last Modified on 10/7/2004

-

APPLIES TO

 Microsoft Access 2002 Standard Edition, when used with:  Microsoft Windows 98 Standard Edition

 Microsoft Windows 98 Second Edition

 Microsoft Windows Millennium Edition  Microsoft Access 2000 Standard Edition, when used with:  Microsoft Windows 98 Standard Edition</li></ul>

 Microsoft Windows 98 Second Edition</li></ul>

 Microsoft Windows Millennium Edition</li></ul> </li></ul>

-

<div class="notice_section">

This article was previously published under Q302502

<div class="notice_section">

Moderate: Requires basic macro, coding, and interoperability skills.

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

<div class="summary_section">

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.

<div class="moreinformation_section">

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: <ol> Click Start, point to Programs, point to Accessories, and then click Notepad.</li>  Type or paste the following code in the Notepad document: CD \ CD \&quot;Program Files&quot; CD \&quot;Program Files\Accessories\Backup&quot; MSbackup.exe </li> Save the text file in the root directory of drive C with the name LaunchMSBackup.bat .</li>  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(&quot;C:\LaunchMSBackup.bat&quot;) </li> Click the command button to run the .bat file, and then close the MS-DOS window that is used by the Shell command.</li></ol>

Additional query words: backup shell Launch

Keywords: kbhowto kbvba KB302502

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.