Microsoft KB Archive/326605

= Issues fixed in Access 2000 by Office 2000 Service Pack 3 =

Article ID: 326605

Article Last Modified on 6/25/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q326605



SUMMARY
Microsoft has released Microsoft Office 2000 Service Pack 3 (SP3). This article describes the issues that are fixed for Microsoft Access 2000.

For additional information about how to download and how to install the Office 2000 Service Pack 3 (SP3), click the following article number to view the article in the Microsoft Knowledge Base:

326585 OFF2000: Overview of Office 2000 Service Pack 3



Access 2000 issues that are fixed by Office 2000 SP3
Office 2000 SP3 fixes the issues that are described in the following Microsoft Knowledge Base articles:

272384 &quot;Overflow&quot; error message when you try to upsize to SQL Server 2000

304548 Error message: Error accessing file. Network connection may have been lost.

260819 SendObject method fails in Access 2000

268379 Turkish: &quot;An error occurred trying to load import/export specification&quot;

311888 Horizontal scroll bar is not displayed on a subform

296130 Font list is not displayed correctly in label wizard dialog box

290346 DBCS characters are not displayed correctly with Zoom Builder

281153 When you export an Access report, Memo field is truncated

293134 The SUM function in a form returns an incorrect value

Additional issues that are fixed by Office 2000 SP3
Additionally, the issues in this section are also fixed by Office 2000 SP3.

IME mode automatically changes when you open or when you create an Access file in Microsoft Windows 2000
The Input Method Editor (IME) mode automatically changes when you:
 * open or create a new Access database.
 * close the database and then open the database.
 * create a new database.

Fatal error occurs when you run code with the OpenReport method in Access 2000
You receive an error message similar to one of the following, and then Access quits. This occurs when you run code that contains the OpenReport method.

Error message 1

Microsoft Visual C++ Runtime Library

Runtime Error!

Program: C:\Program Files\Microsoft Office\Office\MSACCESS.EXE

abnormal program termination

Error message 2

MSACCESS.EXE - Application Error

The instruction at &quot;0x245c8b53&quot; referenced memory at &quot;0x245c8b53&quot;. The memory could not be &quot;read&quot;.

Click on OK to terminate the program

Click on CANCEL to debug the program

Error message 3

This program has performed an illegal operation and will be shut down.

If the problem persists, contact the program vendor.

When you click Details, you receive the following error message:

MSACCESS caused an invalid page fault in at 0000:245c8b53.

You cannot repair a password-protected database
When you open a database that has a database password, you receive the following message:

The database  needs to be repaired or isn't a database file.

You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access database was open.

Do you want Microsoft Access to attempt to repair the database?

When you click Yes, you get the message:

Not a valid password.

This occurs even when you enter a valid password, and Access cannot repair the database.

Linked tables are not in the list of tables you can import to
The Import filetype Wizard does not allow you to import data to an existing table. The In an Existing Table list does not include linked tables as a choice for the tables that you can import data to.

Fatal error resetting code when function is not defined
You receive a fatal error message that is similar to one of the following error messages, or Access stops responding after you reset code that calls a function that is not defined:

Error message 1

MSACCESS.EXE - Application Error

The instruction at &quot;0x65009ea1&quot; referenced memory at &quot;0x00fdffff&quot;. The memory could not be &quot;read&quot;.

Click on OK to terminate the program

Click on CANCEL to debug the program

Error message 2

This program has performed an illegal operation and will be shut down.

If the problem persists, contact the program vendor.

When you click Details, you receive the following message:

MSACCESS caused an invalid page fault in VBE6.dll at 015f:6502c37d.

Text data is converted to numeric data when you export to Excel
When you export a report with text data to Microsoft Excel, the text data is converted from text to a number. This may occur when the data is numeric characters with two periods. For example, the text string of 1.1.1 is converted to 0.0423726851851852.

Chart intermittently displays sample data
Charts in Microsoft Access 2000 reports may intermittently display sample data instead of real data when you Print or when you Print Preview the report.

Access stops responding or generates ODBC call failed when connecting to Oracle
When you try to link to, or import tables or views from an Oracle database, and there are more than 64,000 tables and views, Access stops responding or generates the following error message when it tries to display the table or view names:

ODBC Call Failed

100 percent CPU usage occurs when you hold left mouse button down
When you use any of the Office programs on a Microsoft Windows 2000-based computer, the CPU usage reaches 100 percent if you hold the left mouse button down for more then a few seconds. For additional information about how this affects other Office 2000 applications, click the following article numbers to view the articles in the Microsoft Knowledge Base:

282893 Processor utilization increases to 100 percent when you hold down mouse button

324126 Overview of Excel 2000 SR-1 Update: June 19, 2002

Jet ODBC settings in user profiles are overridden by standard Jet ODBC settings
When you set different values for the Jet ODBC settings in a user profile and the standard Jet ODBC settings, the standard settings take precedent over the user profile settings.

Additional query words: fix list SP3

Keywords: kbinfo KB326605

-

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

© Microsoft Corporation. All rights reserved.