ACC2000: Upsized Chart Is Blank

ID: Q233165

The information in this article applies to:
Moderate: Requires basic macro, coding, and interoperability skills.

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


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.


CAUSE

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


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.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

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.


Additional query words: empty missing information data 


Keywords          : kbdta AutPrb AccessCS 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: July 22, 1999