Best PracticesPeriodic Maintenance of Your Access Database


When using an Access database as the backend for your website, it's often easy to forget about the database's health. Because you're accessing it through a web browser, it's easy to focus more on web functionality and any coding errors and forget that your database might not be performing at its optimal level.

For this reason, it's a good idea to create a periodic maintenance schedule for your Access database. This maintenance schedule might include the following elements:

  • Routine backups of the database and moving those backups to a secure location.

  • Archiving of the database on the local machine so that a copy is readily available in case of database corruption.

  • Periodic usage of the Compact and Repair tool from within Microsoft Access to reduce the size of your database.

  • Periodic defragmentation of the disk where the database is stored to ensure optimal performance.

  • Periodic review of the database size to ensure that size limitations are not being reached.

Adding these tasks to your database maintenance will move you in the right direction toward a worry-free database backend for your website.



Special Edition Using Macromedia Studio 8
Special Edition Using Macromedia Studio 8
ISBN: 0789733854
EAN: 2147483647
Year: 2003
Pages: 337

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net