Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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

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

↑ Back to the top


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.

↑ Back to the top


Workaround

To work around the problem, compact the Access database by using the Compact and Repair Database utility. To do this, follow these steps:
  1. Start Access 2003.
  2. On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.
  3. In the Database to Compact From dialog box, select the database that you want to compact, and then click Compact.
  4. 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.

↑ Back to the top


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.

↑ Back to the top


Keywords: KB828414, kbprb, kbperformance, kbsecurity, kbdatabase, kbopenfile, kbsavefile

↑ Back to the top

Article Info
Article ID : 828414
Revision : 5
Created on : 7/28/2006
Published on : 7/28/2006
Exists online : False
Views : 323