Issues fixed in Access 2000 by Office 2000 Service Pack 3

Article translations Article translations
Article ID: 326605 - View products that this article applies to.
This article was previously published under Q326605
Expand all | Collapse all

On This Page

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

MORE INFORMATION

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 "Overflow" 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: "An error occurred trying to load import/export specification"
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 "0x245c8b53" referenced memory at "0x245c8b53". The memory could not be "read".

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 <unknown> 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 database name 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 "0x65009ea1" referenced memory at "0x00fdffff". The memory could not be "read".

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.

Properties

Article ID: 326605 - Last Review: June 25, 2004 - Revision: 5.0
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbinfo KB326605

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com