Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: Upsized Chart Is Blank

ACC2000: Upsized Chart Is Blank

View products that this article applies to.

This article was previously published under Q233165
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

↑ Back to the top

Symptoms

When you open a form or a report that contains a chart that was upsized from a Microsoft Access database, you may receive the following error message:
The recordsource 'ut_qry##' specified on this form or report does not exist.

You misspelled the name, or it was deleted or renamed in the current database, or it exists in a different database.

In the Form or Report's Design view, display the property sheet by clicking the Properties button, and set the RecordSource property to an existing table or query.
When you click OK, you receive the following error message:
An error occurred while sending data to the OLE Server (the application used to create the object).

*You may have tried to send too much data. If you're creating a chart and the chart is based on a query, modify the query so that it selects less data. If the chart is based on a table, consider basing it on a query instead so that you can limit the data.
* You may be using an OLE server that doesn't accept the Clipboard format. * You may not be able to start the OLE server because it's not properly registered. Reinstall it to register it.
* Your computer may be low on memory. Close windows to free up memory, or restart Microsoft Windows.
When you click OK, the form or the report is displayed, but the chart is blank.

↑ Back to the top

Cause

The RowSource property of the upsized chart refers to a view or a stored procedure that does not exist in your Access project.

↑ Back to the top

Resolution

Copy the SELECT statement that you see in the RowSource property of the original chart, and use it to manually replace the value in the RowSource property of your upsized chart.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

More information

If you try to upsize an Access database to Microsoft SQL Server 2000 by using the Upsizing Wizard, you receive the error described in the following article:
272384 ACC2000: 'Overflow' Message When Upsizing to SQL Server 2000

Steps to Reproduce Behavior

1.Open any database that contains a form or a report that has a working chart object.
2.Open the form or the report that has the chart, and verify that the chart returns correct results.
3.Upsize the database that you opened, and select the Create new Access client/server application option under What application changes do you want to make.
4.After the database has been successfully upsized, view and close the Upsizing report.
5.In your new Access project, open the form or report that contains the chart.
6.Click OK to the error messages that are returned, and note that the chart is blank.

↑ Back to the top

Keywords: KB233165, kbpending, kbclientserver, kbbug

↑ Back to the top

Article Info
Article ID : 233165
Revision : 2
Created on : 6/24/2004
Published on : 6/24/2004
Exists online : False
Views : 339