Article ID: 233165 - View products that this article applies to.
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:
When you click OK, you 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, the form or the report is displayed, but the chart is blank.
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.
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:
(http://support.microsoft.com/kb/272384/EN-US/ )ACC2000: 'Overflow' Message When Upsizing to SQL Server 2000
Steps to Reproduce Behavior
Contact us for more help
Connect with Answer Desk for expert help.