Article ID: 836030 - View products that this article applies to.
Microsoft has released Microsoft Office XP Service Pack 3 (SP3). This article describes the issues that are fixed for Microsoft Access 2002.
For additional information about how to download and install the Office XP SP3, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/832671/ )Description of Microsoft Office XP Service Pack 3
Access 2002 issues that are fixed by Office XP SP3The Office XP SP3 fixes the issues that are described in the following Microsoft updates:
The update fixes issues that are described in the following hotfix package:
823808The update fixes the issues that are described in the following Microsoft Knowledge Base articles:
(http://support.microsoft.com/kb/823808/ )Access 2002 post-Service Pack 2 hotfix package: July 18, 2003
(http://support.microsoft.com/kb/328933/ )Numbers that are copied from Access 2002 paste as text in Excel 2002
(http://support.microsoft.com/kb/329883/ )Access 2002 SnapShot object does not appear as expected when you insert it into a document
(http://support.microsoft.com/kb/331989/ )ACC2002: Memory is not released when you close forms and reports
(http://support.microsoft.com/kb/814094/ )ACC2002: Error message: Cannot apply filter on one or more fields that are specified in the filter property
(http://support.microsoft.com/kb/821185/ )ACC2002: You are prompted to convert your Access 97 database repeatedly when you open the file in Access 2002
(http://support.microsoft.com/kb/821809/ )ACC2002: Microsoft Access quits when you link ODBC tables
Additional issues that are fixed by Office XP SP3The issues in this section are also fixed by Office XP SP3.
When you save a report to rich text format, the report loses parameter informationWhen you export an Access 2002 report to rich text format (RTF), parameters that appeared correctly in the report during Print Preview do not export into the new RTF file. The parameters do not appear in the exported document.
When you view data access pages, they do not appear correctlyIf you view the data access page for a database, some or none of the expected fields appear correctly. This problem occurs after you install Microsoft Internet Explorer 6.0, or after you perform a side-by-side installation of Microsoft Office Access 2003 on the same computer.
You receive an error message after you convert an Access 2003 MDB to Access 2002When you save an Access 2003 Microsoft Access database (MDB), with an MDE, to the Access 2002 format, and then re-create the MDE for the.mdb file, if you try to use any buttons or other scripted functions on a form, you receive the following error message:
The Visual Basic for Applications project in the database is corrupt.
The OpenArgs function only works one time in a VBA projectIf your Microsoft Visual Basic for Applications (VBA) code for a form makes a call to the OpenArgs function after you open the form in design mode, you may receive the following VBA error message:
Run-time error: 94
Invalid use of Null
The DoCmd.ApplyFilter function will not affect the active form after you lock the computerWhen you lock your computer while you have two Microsoft Access forms open, when you unlock the computer and try to activate the DoCmd.ApplyFilter function on the active form, the filter will be applied to the other form instead. This problem occurs when the active form uses the OnResize event and the computer is running Microsoft Windows XP.
When you open a data page in Browse view, you receive the "Egenskapen DefaultSort er ugyldlg" error messageIn the Norwegian version of Access 2002, if you open a data page in Browse view, you receive the following error message:
This problem occurs if you use one of the following functions on a numeric field: Max or Min.
Egenskapen DefaultSort er ugyldlg.
You receive an error message in Modsync.exe when you try to make a data page available offline in Internet ExplorerWhen you view an Access data page in Microsoft Internet Explorer and then try to make it available offline, you receive the following error message:
mobsync.exe - Application Error
The instruction at "memory_location" referenced memory at "memory_location". The memory could not be "read".
Click on OK to terminate the program
Click on CANCEL to debug the program
When you try to make an Access 2002 data page available offline, you receive an error messageWhen you try to make an Access 2002 data page available offline, you may receive the following error message:
Could not create any records form the XML document located at "memory_location". Check to make sure that the document exists, the path to the document is correct, and that you have the appropriate access permissions.
When you cancel a cross-domain warning message, you receive a general protection faultWhen you create a data page that accesses an SQL server by using Microsoft Windows NT authorization, and then cancel a cross-domain warning message, you may receive a general protection fault from Microsoft Access.
When you edit a saved data page in Access 2002, you receive a "Microsoft Access is unable to load the database schema." error messageWhen you try to edit a saved data page in Access 2002, Access will open the data page and then you may receive the following error message:
If you try to update the data page from the field list, you receive the following error message:
Microsoft Access is unable to load the database schema. Save was disabled. Either repair or reinstall Microsoft Office XP.
Microsoft Access is unable to connect to the data source specified in the connection string of this page.
The server may not exist on the network, or there may be an error in the connection sting information for this page
You receive an Access 2002 error messageYou receive the following Access 2002 error message:
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:
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.
Additionally, other program versions, module versions, and offsets are possible.
App Name App Version Module Name Module Version offset ------------------------------------------------------------------------ msaccess.exe 10.0.2627.1 msctf.dll 5.1.2409.7 0001ccb5
Snapshot Viewer prints characters with extra spaces or with random resultsWhen you print a Snapshot Viewer file that contains Japanese characters, you may experience one or more of the following symptoms: