Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Boston, Mass. USA
    Posts
    81

    Unanswered: Scheduling Comact and Repair Utility to run itself?

    Is there any way to set up the "Compact and Repair Database" function to automatically run by itself, say in the middle of the night?

    I have a multi-user database with 100,000+ records used by about 20 users. The main data entry form involves 11 subforms each writing to separate tables. That database has been needing to be compacted more frequently recently for efficiency.

    However, more users are now wanting to work after hours, so it is becoming a hassle to get everyone to shut down at 5pm so I can run this then. Also, I cannot stay late every time this needs to be done--and for now i'm the only one who can do it.

    Is there any way to get this to run automatically? Is it necessary to buy additional software?

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

    DoCmd.RunCommand acCmdOptions

    you will be able to run a command form the options Menu

    I'm not sure





  3. #3
    Join Date
    Oct 2003
    Location
    US
    Posts
    343
    Check this out. Hopefully that'll fix your problem

    http://support.microsoft.com/default...B;en-us;158937

Posting Permissions

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