Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Apr 2001
    Location
    KY USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatically compacting (97 sr2 )

    I did not find anything in my search, so here's the question: Can I automatically compact an Access 97 database programatically? Perhaps "On Close" or such. I know you can with Access 2k.

    Thanx much,

    Jeff

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Automatically compacting (97 sr2 )

    There isn't a simple option to compact on close like there is in 2K, but you can do it through code associated with the close of the database. Try searching the MS knowledge base for Access 97 and compact.
    Wendell

Posting Permissions

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