Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/103405

From BetaArchive Wiki
Knowledge Base

Article ID: 103405

Article Last Modified on 1/18/2007


  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition

This article was previously published under Q103405

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


While it is possible to quit Microsoft Windows from within a Microsoft Access program by making use of the Windows application programming interface (API) function ExitWindows(), Microsoft Windows will not shut down cleanly. Open files in Windows-based applications may not be saved, and temporary (.tmp) files may be left on your hard disk.

This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information about Visual Basic for Applications, please refer to your version of the "Building Applications with Microsoft Access" manual.

NOTE: Visual Basic for Applications is called Access Basic in Microsoft Access versions 1.x and 2.0. For more information about Access Basic, please refer to the "Introduction to Programming" manual in Microsoft Access version 1.x or the "Building Applications" manual in Microsoft Access version 2.0


The sample function listed below demonstrates another method of shutting down Windows from within Microsoft Access. This method will save open files before shutting down, and will not leave .tmp files on your hard disk.

   Function QuitWindows ()
      SendKeys "%{F4}S~", False
      AppActivate ("Program Manager")
   End Function

In the sample function above, the QuitWindows() function activates the Microsoft Windows Program Manager, and then sends the keystrokes necessary to instruct Program Manager to close Windows. This function works in Windows 3.x, Windows NT, and Windows 95 (even though there is no Program Manager in Windows 95).


For more information about exiting to MS-DOS, please see the following article in the Microsoft Knowledge Base:

89596 ACC: Using Microsoft Access Macro to Quit Windows

Additional query words: exiting exit

Keywords: kbhowto kbprogramming KB103405