Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2008
    Posts
    189

    Question Unanswered: Any way to automate the db file compact?

    Hello,
    Are there any way to automatically compact the Access db file?

    I mean, is there any software that do an automatic compact of the db file on nights? Like with a timer.

    Some other way to do the attached file?
    I want to do it at night when no one is in front of the computer.

    Was I clear? Sorry terrible English
    Attached Thumbnails Attached Thumbnails Dibujo.JPG  

  2. #2
    Join Date
    Apr 2008
    Posts
    189
    Ok, here is one way:
    http://www.todoexpertos.com/categori...utomaticamente

    And the software is this one:
    http://support.microsoft.com/kb/295334/EN-US/

    Any thoughts?
    Thanks!

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    im not sure you need to do that
    you can schedule any task using the windows scheduler
    Im pretty certain you can, using comnand line switches, open a copy of Access and comapct and repair your application

    but if you've fpoudn a way that works, good or you....
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Apr 2008
    Posts
    189
    Thanks healdem!

    Can you tell me the command line to compact and repair?

    Thanks again for your help!

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Access command line switches can be found here
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Apr 2008
    Posts
    189
    Thanks healdem!

Posting Permissions

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