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,438
    Thanks
    33
    Thanked 196 Times in 176 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

    "The trouble with quotes on the internet is that you can never know if they are genuine."
    Abraham Lincoln
    

  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,438
    Thanks
    33
    Thanked 196 Times in 176 Posts

    Re: Teminating Access (database) cleanly (2003)

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

    "The trouble with quotes on the internet is that you can never know if they are genuine."
    Abraham Lincoln
    

Posting Permissions

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