Slow performance results when you add a digital certificate to an Access database (828414)

This article applies only to a Microsoft Access database (.mdb).

Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

When you add a digital certificate to a Microsoft Office Access 2003 database, you may experience a delay when you open the database. A delay may also occur when you close the database, when you save the database, or when you save the database objects.

WORKAROUND

To work around the problem, compact the Access database by using the Compact and Repair Database utility. To do this, follow these steps:

Start Access 2003.
On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.
In the Database to Compact From dialog box, select the database that you want to compact, and then click Compact.
In the Compact Database Into dialog box, type the file name in the File name text box, and then click Save.

Note You can avoid this problem if you compact the Access database before you add a digital certificate to the Access database.

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

823225 "Project Is Unviewable" Error Message While Opening a Visual Basic for Applications Project in Microsoft Access

For more information about the Compact and Repair Database utility, click Microsoft Office Access Help on the Help menu, type compact and repair an Access file in the Search for box in the Assistance pane, and then click Start searching to view the topic.