Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Europe
    Posts
    369

    Question Unanswered: compressing from a batch file/command line?

    I want a backup routine to copy a mdb file while opened (using SecondCopy from www.centered.com for this, works fine), then compress the file before putting it in a pw protected zip file and backing it up to a secure storage on the internet.

    Can I trigger a compression of the mdb from the command line (in a batch file), and automatically resume the batch operation when the compression is done?

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: compressing from a batch file/command line?

    Originally posted by kedaniel
    I want a backup routine to copy a mdb file while opened (using SecondCopy from www.centered.com for this, works fine), then compress the file before putting it in a pw protected zip file and backing it up to a secure storage on the internet.

    Can I trigger a compression of the mdb from the command line (in a batch file), and automatically resume the batch operation when the compression is done?
    To compress ACCE$$ file it should be closed, so you can make a new ACCE$$ file called CompressIt for example, which contains the orders to compress your original ACCE$$ file, and then call this CompressIt.mdb from the Command line

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Sorry, forgot to tell you about the command to compress a closed DB.
    It is application.DBEngine.CompactDatabaseJust look it up and see some examples.

Posting Permissions

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