Microsoft KB Archive/942378

= Issues that are fixed in Access 2007 by the 2007 Microsoft Office suites Service Pack 1 =

Article ID: 942378

Article Last Modified on 12/12/2007

-

APPLIES TO


 * Microsoft Office Access 2007

-



SUMMARY
Microsoft has released a service pack that contains fixes for Microsoft Office Access 2007.



INTRODUCTION
The 2007 Microsoft Office suites Service Pack 1 (SP1) provides the latest updates to Access 2007. This service pack contains security improvements, stability improvements, and performance improvements. Some fixes that are included with this service pack were previously released in separate updates. This service pack combines these previously released fixes into one update.

For more information about the 2007 Microsoft Office suites SP1, click the following article number to view the article in the Microsoft Knowledge Base:

936982 Description of the 2007 Microsoft Office suites Service Pack 1



Downloadable list of issues that the service pack fixes
A Microsoft Office Excel workbook is available that contains a list of the Access 2007 issues that are fixed by the 2007 Microsoft Office suites SP1.

Note The workbook is in the English language. The workbook will not be translated into any other languages.

The following file is available for download from the Microsoft Download Center:

Download the Office Servers Service Pack 1 Changes_all.xls package now.

Release Date: December 11, 2007

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Issues that the service pack fixes
The 2007 Microsoft Office suites SP1 fixes the Access 2007 issues that are described in the following hotfix packages:

939185 Description of the Access 2007 hotfix package: June 24, 2007

936519 Description of the Access 2007 hotfix package: April 27, 2007

935875 Description of the Access 2007 hotfix package: April 11, 2007

935521 Description of the Access 2007 hotfix package: April 8, 2007

Issues that were not previously documented in a Microsoft Knowledge Base article
This service pack also fixes the following issues that were not previously documented in a Microsoft Knowledge Base article:  The column operations target the subdatasheet instead of the Add New Field column in Access 2007

When you click the Add New Field column in the main datasheet, Access 2007 does not take focus out of its subdatasheet. Therefore, the data type of the most recently focused column in the subdatasheet is changed when you try to add a new column to the main datasheet by using the Data Type drop-down box. When you import Outlook contacts into Access 2007, unexpected characters may appear in the Mail Merge Recipients dialog box

This problem occurs when the Outlook contacts contain Romanian characters.

 &quot;Update existing data&quot; e-mail messages that update a Yes field and a No field cannot be processed because they contain an English value

If you send an &quot;update existing data&quot; e-mail message that contains a Yes field and a No field, a system that uses non-English language settings cannot process replies to the message. This is true if the user does not manually localize the value within the Yes field or within the No field.

Additionally, the &quot;yes&quot; string and the &quot;no&quot; string are not localized when you create an HTML Data Collection form that contains a Boolean field. You receive a security prompt and error messages when you use the Label Wizard in Access 2007

When you use the Label Wizard in Access 2007, you receive a security prompt. If you click OK on the security prompt, you receive an error message. If you click Yes on the error message, you are returned to the Label Wizard. When you try to finish the wizard again, you may receive another error message. Error message when you execute a query that contains parameters in Access 2007: &quot;Syntax error in Parameter clause&quot;

In Access 2007, you receive the following error message when you try to execute a query that contains parameters:

Syntax error in Parameter clause

 Access 2007 does not return more than 2,000 records from a User Information table that is linked from SharePoint

Access 2007 returns only the first page of records from a User Information table. The first page of records contains no more than 2,000 records.

Note This issue also occurs in Microsoft Office Access 2003 Service Pack 2 (SP2). The page controls for the transparent tab are not transparent in Access 2007

In Access 2007, the page controls for the transparent tab are not transparent. This issue occurs on any Microsoft operating system, such as Windows Vista or Windows XP, that has themes turned on and that has themes enabled by default.</li> Access 2007 takes several minutes to repair itself

You install Access 2007 and Access 2003 on the same computer. When you run Access 2007 after you run Access 2003, Access 2007 takes several minutes to repair itself.</li> You can still update the AutoNumber field data after you run an update query that sets an AutoNumber field to Null

After you run an update query that sets an AutoNumber field to Null in Access 2007, and then you compact the database, you can still update the AutoNumber field data. However, the ability to update AutoNumber fields should be removed. This issue may result in a loss of data. After you compact the database, the MSysCompactError table is created.</li> When you open a form that is bound to a SharePoint table in a read-only database in Access 2007, you can add data to the form

When you open a form that is bound to a Microsoft Office SharePoint table, you can add data to the form. However, when the form is closed, the data is lost. This behavior does not let you add data to a form in a read-only database in Access 2007. The form is bound to a SharePoint table.</li> Access 2007 cannot recognize a custom shortcut menu bar in a form

When you open a custom shortcut menu bar in a form in Access 2007, the shortcut menu is missing. Additionally, you may receive an error message that states that the shortcut menu does not exist when you open the database again.</li> On a Windows Vista-based computer, fields that are bound to time-intensive expressions are blank in Access 2007

Fields that are bound to time-intensive expressions are blank in Access 2007. These fields are empty until you click the text box or until you click anything outside of Access 2007 if the following conditions are true: <ul> The Control Source property of a text box uses the DLookup function.</li> The query that is called by the DLookup function references a control on a form.</li></ul> </li> When you paste some text fields from Excel to Access 2007, the text fields are detected as memo fields

Text fields are detected as memo fields when you paste some text fields from Microsoft Office Excel to Access 2007. When Access 2007 detects columns that have fewer than 255 characters, &quot;fields of type&quot; text is created.</li> An error occurs when you select a date by using the Date picker control and when the Bulgarian regional setting is enabled

This issue also occurs in any language version of Access 2007 that has the Bulgarian regional setting enabled.</li> A selected item does not become visible when you programmatically select the item in a list on a form in Access 2007

When you programmatically select an item in a list on a form, the selected item does not become visible if it was not visible before you selected it in Access 2007.</li> In Access 2007, the click event for an image control does not work when the image control is inside a tab control

In Access 2007, the click event for an image control does not work when the image control is inside a tab control.</li> You cannot use the OpenRecordset function to open some DAO database objects through Open Database Connectivity (ODBC) connections in Access 2007</li> The behavior of the StopAllMacros macro action is swapped with the behavior of the StopMacro macro action in Access 2007</li> The DoCmd.SelectObject method does not return an error if the object does not exist

You create a macro that uses the DoCmd.SelectObject method to select an object in the database by name. If you specify the name of an object that does not exist in the database, you do not receive an error message. Additionally, nothing happens.</li> Access 2007 takes more time to import large .csv files than Access 2003 does

When you try to import a large .CSV file, such as a file that is larger than 30 megabytes (MB),, Access 2007 appears to stop responding at the import dialog box. After several moments, you may receive the following error message:

File sharing lock count exceeded. Increase MaxLocksPerFile registry Entry

When you click OK to close the error message, you can usually finish the import process. All records are imported successfully.</li> <li>When Access 2007 imports numeric data from Excel as the long integer data type, some numbers may be wrong

When you import data from an Excel spread sheet into Access 2007 by using the long integer data type, the number 1 is incorrectly added to some numbers.</li> <li>In Access 2007, the modified date for all objects, except tables and queries, is never updated

In Access2007, the modified date that is displayed in the Navigation Pane for all objects, except tables and queries, is never updated.</li> <li>You cannot convert an .accdb file to Access 2002-2003 format by using a linked .csv file

When you try to convert an .accdb file to an .mdb file, nothing happens. You do not receive an error message.</li> <li>Error message when you change the Enabled property of a check box by running a macro that uses the SetValue action in Access 2007: &quot;Access failed to evaluate one or more expressions&quot;

When you change the Enabled property of a check box on a form by running a macro that uses the SetValue action, you may receive the following message when the sandbox is enabled:

Access failed to evaluate one or more expressions because 'Enabled' was referenced in an expression. Only functions and properties that are considered to be safe are allowed in expressions when Access runs in sandbox mode.

For more information on sandbox mode, search for &quot;Sandbox mode&quot; in Access Help.

</li> <li>The floating User interface for attachments and for text formatting is not displayed correctly in runtime mode in Access 2007

When you open a database in runtime mode, the floating UI for attachment controls and for formatting in rich-text enabled fields is not displayed correctly.

</li> <li>When you update referenced cells in Excel data through the ISAM by using code, the wrong cell may be changed

When you update referenced cells, you update the literal cell address instead of the referenced cell. This issue occurs when you update Excel data through the ISAM programmatically.</li> <li>When multiple items are selected in the Navigation Pane, the wrong objects are deleted in Access 2007 if you use the shortcut menu to delete the objects

When you try to delete multiple objects by using the delete option on the shortcut menu, database objects that were not selected may be incorrectly deleted.

</li> <li>The Access 2007 list selection works differently from earlier versions of Access

You cannot use code that uses the index of the item in a list to set the selection.

</li> <li>Records in sub-forms cannot be deleted in Access 2007

When you try to delete a record in a sub-form that is embedded in a main form, the row is longer displayed. However, the record is actually not deleted. If you press F9 after you delete a row in the sub-form, you receive the following error message:

Operation not supported in transactions

</li> <li>Error message when you run a union query that has more than one union on tables with complex data: &quot;The Microsoft Office Access database engine could not find the object&quot;

When you add an attachment field to a table, you may receive the following error message:

The Microsoft Office Access database engine could not find the object.

Make sure the object exists and that you spell its name and the path name correctly.

This issue occurs when the field has a union query that has more than one union on tables with complex data.</li> <li>When you set the data type of a new field to a non-text type, such as Attachment, in the Datasheet view, Access 2007 may stop responding</li> <li>When you return to the property sheet after you change the RecordSource property, Access 2007 may stop responding

This issue may occur after you click Builder in the property sheet in order to open the QBE.</li></ul>

Error signature details
When you use an Access 2007 program, you may receive an error message that resembles the following:

Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. To see what data this error report contains, click here.

When you view the data in the error report, the report contains an error signature that resembles one of the following error signatures.

Additionally, other program versions, module versions, and offsets are possible. These problems are fixed in 2007 Office Suite SP1.

Keywords: kbtshoot kbfix kbprb kbupdate kbgetsp kbexpertiseadvanced KB942378

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.