Jan 12

Microsoft Access Database Compact and Repair to Minimize Corruption and Avoid Bloat (by Access Version)

File server databases like Access/JET MDB and ACCDB files need to be periodically compacted and repaired for optimal performance and to minimize database corruption. This also eliminates database bloat that can occur as data is added and deleted in the database. Here's a Microsoft Knowledgebase article that discusses some of the issues.

Microsoft Access databases can be manually compacted from the Access menu. Unfortunately, over the last few versions of Access, the location of this command has moved around driving Access many users and developers crazy. Read this paper for how performing this critical system administration task across all versions of Access:

Microsoft Access Database Compact and Repair to Minimize Corruption and Avoid Bloat (by Access Version)

 

Jan 12

Create a Backup and Disaster Recovery Plan for Microsoft Access Database Applications

Microsoft Access Backup Disaster Recovery Plan

If you create or take over a Microsoft Access application from someone else, you become responsible for the data in addition to the application and its queries, forms, reports, macros, and module code. Unanticipated disasters can occur, so it's important to prepare before they happen. The amount of effort and investment to spend for disaster recovery varies with the value of the application, but some basics apply to all applications.

A Disaster Recovery Plan is much more than making backups of your database. And if your backups are on the same machine and/or hard disk as your production database, that doesn't qualify. 

Read our paper on Creating a Backup and Disaster Recovery Plan for Microsoft Access Database Applications  for ways to limit your risk and headaches, while providing a professional solution for your end-users, boss, and clients.

Jul 15

Total Visual Agent 2007 is Shipping

Total Visual Agent is the system administration tool for professionally maintaining your Microsoft Access databases. Our seventh major release, Total Visual Agent 2007 is now shipping with full support for Access 2007 including the Access 2007 ACCDB database format. It incorporates many new features including improved support of Windows NT Service options, ADPs, and a more modern user interface.

Microsoft Access Jet Databases (MDB and ACCDB formats) need to be periodically compacted and repaired for optimal performance (visit the Microsoft site for keeping Jet databases working in top condition for more information). You also need to make regular backups or multiple backups for disaster recovery. Schedule these database chores, manage entire folders or disk drives, and ensure tasks are executed consistently and audited. If something goes wrong, Total Visual Agent can actually send you an email. You can also schedule your own tasks such as running a macro in a database, which can perform all sorts of work such as printing reports, downloads, file transfers, and other processes you want on a regular basis. Tasks can be run monthly, weekly, daily, hourly, or just one time. Schedule your tasks and confidently know they'll be executed according to your plan.