ACC2000: Combo Box or List Box Empty After You Use Upsizing Tools

This article was previously published under Q229755
This article has been archived. It is offered "as is" and will no longer be updated.
Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS
After you use the Microsoft Access Upsizing Tools to migrate your database to a Microsoft Access client/server application, combo boxes and list boxes that previously functioned correctly now are blank or return the following error message when you use them:
The recordsource 'ut_qry##' specified on this form or report does not exist.
CAUSE
The Rowsource property of the combo box or list box contains one of the following values:
  • A query that uses parameters
  • A query or SELECT statement that references a control on a form in its WHERE clause
  • A SELECT statement that does not specify each output column by using the format [TableName].[FieldName]
RESOLUTION
In your Microsoft Access project, create a stored procedure that returns the data that you want to display in your data-bound control. Then, use the stored procedure in the RowSource property of the control that does not work correctly.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Access 2002.
MORE INFORMATION
Steps to Reproduce Behavior
  1. Open the sample database Northwind.mdb.
  2. Create the following form:
       Form: MyForm   ----------------------   Caption: Upsizing Test   RecordSource: None   Combo box   ----------------------------------------------------------------------   Name: Field1   RowSource: SELECT [Categories].[CategoryID],[Categories].[CategoryName]               FROM Categories               ORDER BY [CategoryName] DESC;					
  3. Open the form in Form view and verify that the combo box works correctly.
  4. On Tools menu, click Database Utilities, and then click Upsizing Wizard.
  5. Upsize all tables in the database to SQL Server or MSDE, making sure to select Create a new client-server application in the What application changes do you want to make option group.
  6. After the Upsizing Wizard is finished, examine and close the Upsizing Report. Note that the newly created Access project opens automatically.
  7. Open the MyForm form in Form view, and try to show the list of values that should appear in the combo box.
REFERENCES
For more information about the Upsizing Wizard, click Microsoft Access Help on the Help menu, type upsizing wizard in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
pra the recordsource ut_qry## specified on this form or report does not exist
Properties

Article ID: 229755 - Last Review: 12/29/2014 13:33:30 - Revision: 2.0

  • Microsoft Access 2000 Standard Edition
  • kbnosurvey kbarchive kbbug kbpending KB229755
Feedback