Best practice for Compact/Repair Database Utility in Access Database General Questions    |   |  Help   Search For:     In:   Office   Access Database     Access Database General Questions     Access Database New users     Access Database design     Access Database Forms     Access Database Forms Coding     Access Database Import/Export Data     Access Database Install and Configure     Access Database Macros     Access Database Programming     Access Database Queries     Access Database Reports     Access Database Security              Pat Dools 1/25/2005 3:49 AM PST   Question   As a general rule, how often should the 'Compact/Repair Database' utility be run on an Access 2003 database? Should it only be run if you suspect corruption, or is it a good idea to run on a regular basis (e.g., once a week)? Thanks. -- Pat Dools     Was this post helpful to you?         Reply |   Top           anonymous@discussions.microsoft.com 1/25/2005 4:09 AM PST   Answer   hi, on a regular basis. how often? depends on how much it is used, number of users, ect. more usage, the more you need to compact. i would monitor db size before and after compact for a time period. that should give you some idea of how often. we do it once a week. >-----Original Message----- >As a general rule, how often should the 'Compact/Repair Database' utility be >run on an Access 2003 database? Should it only be run if you suspect >corruption, or is it a good idea to run on a regular basis (e.g., once a >week)? > >Thanks. >-- >Pat Dools >. >     Was this post helpful to you?         Reply |   Top           Arvin Meyer 1/25/2005 4:18 AM PST   Answer   My users generally download fresh copies of the front-end every time they open the database, so there is no need to compact. The back-end is in use an average of 10 or 11 hours a day (sometimes more) so I use Total Access Agent to compact every morning at 2:00 AM. When we were doing it manually, I generally was able to compact it once a week. http://www.fmsinc.com/Products/Agent/index.html -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access "Pat Dools" <PatDools@discussions.microsoft.com> wrote in message news:15D68DB9-BD51-4A82-8BF5-3F3184057501@microsoft.com... > As a general rule, how often should the 'Compact/Repair Database' utility be > run on an Access 2003 database? Should it only be run if you suspect > corruption, or is it a good idea to run on a regular basis (e.g., once a > week)? > > Thanks. > -- > Pat Dools     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies