ACC2000: Upsized Chart Is Blank

This article was previously published under Q233165
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.

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

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.
The RowSource property of the upsized chart refers to a view or a stored procedure that does not exist in your Access project.
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.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
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.
empty missing information data the recordsource ut_qry## specified on this form or report does not exist

Article ID: 233165 - Last Review: 10/21/2013 22:21:18 - Revision: 2.0

Microsoft Access 2000 Standard Edition

  • kbnosurvey kbarchive kbbug kbclientserver kbpending KB233165