Results 1 to 3 of 3
  1. #1
    Super Moderator BATcher's Avatar
    Join Date
    Feb 2008
    Location
    A cultural area in SW England
    Posts
    3,413
    Thanks
    33
    Thanked 195 Times in 175 Posts

    Teminating Access (database) cleanly (2003)

    We have a vendor-supplied database written in Access with a huge amount of code written round it.

    I would like to be able to have a standard method of terminating it cleanly, and wonder whether there is any practical difference between:<UL><LI>clicking on File -> Exit at top left of Access Screen<LI>clicking on the X at the top right of the Access screen<LI>running TASKKILL /FI "imagename eq msaccess.exe" from a desktop icon<LI>logging off the user with the Access screen still active[/list]I know logging off while Access is still active might not be the best idea imaginable - but does it actually cause problems, even if the database is still open?

    Thanks!
    BATcher

    Time prevents everything happening all at once...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Teminating Access (database) cleanly (2003)

    It depends on the database. It is possible to disable File | Exit and the X button in the upper right corner of the Access application window, so that the user has to click a button provided by the designer of the database to close it and exit Access. Also, the designer might display a message box or similar when the database is closed. In such cases, you'd have to add the /F parameter.

    Otherwise, there is no real difference: as far as I know, both TASKKILL and logoff try to close all open applications gracefully.

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17> I assume that it is not a problem for you that TASKKILL is not available in Windows XP Home

  3. #3
    Super Moderator BATcher's Avatar
    Join Date
    Feb 2008
    Location
    A cultural area in SW England
    Posts
    3,413
    Thanks
    33
    Thanked 195 Times in 175 Posts

    Re: Teminating Access (database) cleanly (2003)

    Thanks, Hans - no problem at all, since it is Windows Server 2003 R2 Terminal Services client!
    BATcher

    Time prevents everything happening all at once...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •