Microsoft KB Archive/906460

= Issues that are fixed in Access 2003 by Office 2003 Service Pack 2 =

Article ID: 906460

Article Last Modified on 2/15/2006

-

APPLIES TO


 * Microsoft Office Access 2003

-



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



INTRODUCTION
Microsoft Office 2003 Service Pack 2 (SP2) provides the latest updates to Microsoft Office Access 2003. Some of the fixes that are included with Office 2003 SP2 were previously released in Office 2003 Service Pack 1 (SP1) or in separate updates. Office 2003 SP2 combines the previously released fixes into one update. For more information about Office 2003 SP2, click the following article number to view the article in the Microsoft Knowledge Base:

887616 Description of Office 2003 Service Pack 2



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

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 Office2003_SP2Changes.exe package now. Release Date: September 27, 2005

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 were previously documented in the Microsoft Knowledge Base
Office 2003 SP2 fixes the Access 2003 issues that are described in the following hotfix packages:

838900 Description of the Access 2003 post-Service Pack 1 hotfix package: August 20, 2004

873334 Description of the Italian version of Access 2003 post-Service Pack 1 hotfix package: December 17, 2004

886672 Description of the Access 2003 post-Service Pack 1 hotfix package: September 24, 2004

887971 Description of the Access 2003 post-Service Pack 1 hotfix package: November 1, 2004

889186 Description of the Access 2003 post-Service Pack 1 hotfix package: November 12, 2004

890931 Description of the Access 2003 post-Service Pack 1 hotfix package: December 14, 2004

892470 Description of the Access 2003 post-Service Pack 1 hotfix package: January 19, 2005

893167 Description of the Access 2003 post-Service Pack 1 hotfix package: January 31, 2005

894469 Description of the Access 2003 post-Service Pack 1 hotfix package: February 25, 2005

894787 Description of the Access 2003 post-Service Pack 1 hotfix package: February 26, 2005

896013 Description of the Microsoft Office Access 2003 post-Service Pack 1 hotfix package: March 26, 2005

898072 Description of the Access 2003 post-Service Pack 1 hotfix package: April 28, 2005

Issues that were not previously documented in the Microsoft Knowledge Base
Office 2003 SP2 also fixes the following Access 2003 issues that were not previously documented in the Microsoft Knowledge Base.

You receive a &quot;This database is in an unrecognized format&quot; error message when you open a database that was originally created in Access 2000

When you open an .mdb file in Access 2003, the database file does not open. Additionally, you receive the following error message:

This database is in an unrecognized format.

The database may have been created with a LATER version of Microsoft Office Access than the one you are using. Upgrade your version of Microsoft Office Access to the current one, then open this database.

This problem may occur if the original database file was created in Access 2000 and then converted to Database (Access 2002 - 2003 file format).

You receive a &quot;Run-time error '2467'&quot; error message when you work with a control programmatically in the detail section of a report

When you work with a control programmatically in the detail section of a report, the Visual Basic for Applications (VBA) macro stops. Additionally, you receive the following error message:

Run-time error '2467':

The expression you entered refers to an object that is closed or doesn't exist.

This problem may occur if a control is contained in the header of the report.

The registry keys for the Snapshot Viewer control are updated

Office 2003 SP2 updates the registry keys that are added when you add the Snapshot Viewer control to a UserForm in Access 2003.

A record in a linked SQL Server 2000 database table is not correctly updated when you modify the record in an Access 2003 database table

When you modify a record in an Access 2003 database table, the record in the linked Microsoft SQL Server 2000 database table is not correctly updated. Instead, the new data is recorded in the wrong record.

This problem occurs if the record that you modify is displayed as part of the recordset that is returned by a query. For example, the record might be displayed in a subform. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

903074 BUG: A record in a linked SQL Server 2000 database table is not correctly updated when you modify the record in an Access 2003 database table

The Filter property is not applied in a UserForm

You run Access 2003 in sandbox mode. When you try to use the Filter property in a UserForm, the property is not applied in the UserForm.

For more information about Microsoft Jet Expression Service sandbox mode, click Microsoft Office Access Help on the Help menu, type sandbox mode in the Search for box in the Assistance pane, and then click Start searching to view the topic.

The DefaultValue property is not applied in a UserForm of an .adp file

You try to use the DefaultValue property to automatically populate a string value in a field. When you try to use the DefaultValue property, a new record is created in a UserForm of an Access project (.adp) file. When this problem occurs, the DefaultValue property is not applied. This problem may occur if you also use the FetchDefaults property in the UserForm.

Known issues after the installation of the service pack
When you try to update the data in tables that are linked to an Excel workbook in Microsoft Office Access 2003, you cannot edit, add, or delete data in the tables

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

904953 You cannot change, add, or delete data in tables that are linked to an Excel workbook in Office Access 2003 or in Access 2002

Error signature details
When you use Access 2003, you may receive an error message that is similar to the following:

Microsoft Office 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 is similar to one of the following error signatures.

Additionally, other program versions, module versions, and offsets are possible.

Additional query words: access2003 access2k3 acc2003 acc2k3

Keywords: kbtshoot kbfix kbupdate KB906460

-

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

© Microsoft Corporation. All rights reserved.