Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005
    Posts
    333

    Unanswered: Compact Database

    I have shared A2K database in which I compact on close. This keeps the size down but the users complain because it takes 30 second or more to close their app. Is there a way to compact the db using a batch file? If there is, I will just use windows scheduler to run the batch every night after the users are gone.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    yes you can.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Feb 2005
    Posts
    333
    yes you can
    And I thought the Mowen was the only one that had permission to answer like that. OK, Let me restate my question: How would I write a batch file that will compact my A2K db?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    have a quick google for Access "compact and repair" batch
    or
    http://www.tek-tips.com/viewthread.c...1013953&page=6
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Feb 2005
    Posts
    333
    Thanks. (Here are extra characters so I can post message)

Posting Permissions

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