Access 2003 Solution Center

Performance

Defragment and compact database to improve performance in Microsoft Access
Explains that you can defragment your hard disk and compact your database to improve the performance of Microsoft Access.
Information about query performance in an Access database
Describes the tips and the techniques that you can use to improve the performance of your queries in Access 2000 databases, in Access 2002 databases, and in Access 2003 databases.
How to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients
Describes how to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients.

The Private Bytes counter in Performance Monitor may continually increase when an ActiveX control that is in an Office 2003 document is updated
Describes a problem when you work with a document that contains an ActiveX control that updates data in the control, the Private Bytes counter in Performance Monitor may continually increase.
You may experience decreased performance when you access network resources or when you use Microsoft Access in Windows 2000
Fixes a problem in Windows 2000 where you experience decreased performance when you access network resources or when you use Microsoft Access.
Poor performance when you append data to a shared file-based database from a Windows XP-based client
Discusses a problem in Windows XP where you experience poor performance when you append records to a shared database that is located on a file server. You must add a registry subkey, verify the Shell32.dll file version, and then apply a hotfix.

Slow performance results when you add a digital certificate to an Access database
Describes the problem that occurs if a digitial certificate is added to an Access 2003 database. You may experience a delay when you open, save, close the database or database objects. Requires basic macro, coding, and interoperability skills.
Slow performance on linked tables in Access 2002, in Office Access 2003, and in Office 2007
Explains that you will receive a performance issue with the linked tables in Access 2002, in Access 2003, or in Access 2007 which are caused by displaying related records in a subdatasheet
Slow performance when user opens an object with Name AutoCorrect enabled in Microsoft Access
Describes a problem that occurs if a database has the Name AutoCorrect feature enabled. Users may experience a delay when they try to open database objects in Access 2002 or Access 2003.