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

How to Migrate Data from Access to SQL Server using SSMA (SQL Server Migration Assistant

SSMA is used to migrate Access databases to SQL Server. This tool converts the Access database to a SQL Server or a SQL Azure database.

By Admin

Adding Objects to the Report

When you return to the Properties window for the Report object, you will see the SQL details in the Record Source field. Now that you have identified which table or tables to select data from, objects need to be added from the table(s) to the report.

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