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.

Back to the top

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.

Back to the top

Hotfix information

A supported hotfix is now 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 2007 Microsoft Office suites service pack that contains this hotfix.

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the hotfix. To submit an online request to obtain the hotfix, visit the following Microsoft Web site:Note If additional issues occur or 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. To create a separate service request, visit the following Microsoft Web site:

Prerequisites

There are no prerequisites for installing this hotfix.

Restart information

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

Hotfix replacement information

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

Registry information

To use one of the hotfixes in this package, you do not have to make any changes to the registry.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.

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 information

File name	File version	File size	Date	Time	Platform
Office-kb949404-fullfile-x86-glb.exe	12.0.6300.5000	6,578,360	25-Feb-2008	08:58	x86

Microsoft Windows Installer .msp file information

File name	File version	File size	Date	Time	Platform
Access.msp	Not Applicable	6,746,112	25-Feb-2008	15:12	Not Applicable

After 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:

File name	File version	File size	Date	Time	Platform
Accwiz.dll	12.0.6300.5000	164,912	08-Dec-2007	08:31	x86
Msacc.olb	12.0.6300.5000	585,776	08-Dec-2007	08:31	x86
Msaccess.exe	12.0.6304.5000	10,378,784	22-Feb-2008	17:11	x86
Msaexp30.dll	12.0.6300.5000	69,176	08-Dec-2007	08:31	x86
Soa.dll	12.0.6300.5000	504,896	08-Dec-2007	08:31	x86

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

Back to the top