Description of the Access 2007 hotfix package: March 6, 2008

This article describes the Microsoft Office Access 2007 issues that are fixed in the hotfix package that is dated March 6, 2008.

• The issues that the hotfix fixes.
• The prerequisites for installing the hotfix.
• Whether you must restart the computer after you install the hotfix.
• Whether the hotfix is replaced by any other hotfix.
• Whether you must make any registry changes.
• The files that the hotfix contains.

Issues that this hotfix package fixes

This hotfix fixes the following issues that are not previously documented in a Microsoft Knowledge Base article:

• When you try to compact and to repair a database in a shared folder, a new database is created. The new database is named as the default name for that version of Access. For Access 2003, the name is "Db1.mdb." For Access 2007, the name is "Database1.mdb." However, the old database is not compacted and not deleted, but the new database is compacted. The same problem occurs if the Compact on Close database option is selected.
• Access 2007 may take a long time to respond when you modify a query from within Design view. This behavior occurs if the tables that the query is based on are from an Open Database Connectivity (ODBC) database data source.

Hotfix information

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site: Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Prerequisites

There are no prerequisites for installing this hotfix.

Restart information

You do not have to restart the computer after you apply this hotfix.

Registry information

To use one of the hotfixeses in this package, you must either create a registry key or modify a registry key.

To have us enable the query part of this hotfix package for you, go to the "Fix it for me" section. To enable the query part of this hotfix package yourself, go to the "Let me fix it myself" section.

Fix it for me

To enable the query part of this hotfix package automatically, click the Fix this problem link. Click Run in the File Download dialog box, and follow the steps in the Fix it wizard.




Note this wizard may be in English only; however, the automatic fix also works for other language versions of Windows.

Note If you are not on the computer that has the problem, you can save the automatic fix to a flash drive or to a CD, and then you can run it on the computer that has the problem.

Next, go to the "Did this fix the problem?" section.

Let me fix it myself

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base: To enable the query part of this hotfix package, follow these steps:

1. Click Start, and then click Run.
2. Copy and then paste (or type) the following command in the Run box, and then press ENTER:
   regedit
3. Locate and then click the following subkey in the registry:
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access\Options
4. On the Edit menu, point to New, and then click DWORD Value.
5. Type NoRichTextExprCheck, and then press ENTER.
6. On the Edit menu, click Modify.
7. Type the following hexadecimal or decimal value, and then click OK: 1
8. Exit Registry Editor.

Did this fix the problem?

Check whether the registry key is created or modified. If the registry key is created or modified, you are finished with this article. If the registry key is not created or modified, you can contact support.

File information

This hotfix may not contain all the files that you must have to fully update a product to the latest build. This hotfix contains only the files that you must have to correct the issues that are listed in this article.

The Global version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

Download informationMicrosoft Windows Installer .msp file informationAfter the hotfix is installed, the Global version of this hotfix has the file attributes, or a later version of the file attributes, that are listed in the following table:Note For more information, click the following article number to view the article in the Microsoft Knowledge Base: