Jet 4.0 Engine

The Jet 4.0 database engine is a crucial component of database performance. Be up to date with Version 8 for systems other than Microsoft Windows 2000, Windows XP, or Windows Server 2003. These releases have additional Service Packs you should download.

By Admin

Hardware Recommendations For Running Access

Hardware matters. Invest in a faster PC and Microsoft Access databases will run faster. Be alert for sellers packaging fast processors with minimal memory and a slow hard drive to keep prices low. Look at all aspects of the purchase when database speed is a priority. A faster hard drive is worth the investment and more memory will help!

By Admin

Access Databases Compacting Tips

Compact an Access database periodically by selecting 'Compact and Repair'. Compacting allows Access to rearrange the data in the same way you might rearrange your spice shelf. It fills in the space left behind by the deleted objects.

By Admin

Access Report and Form Tips

Avoid restricting records or performing calculations within the form or report. Place record restrictions and complex calculations at the query level. Use a filter only if absolutely necessary and only at the query level.

By Admin

Access Table Design Tips

Use table normalization whenever possible. Normalizing tables is highly recommended since it will reduce several tables into a few tables. Refer to the features section on how to normalize data.

By Admin