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

Article translations Article translations
Article ID: 229755 - View products that this article applies to.
This article was previously published under Q229755
Advanced: Requires expert coding, interoperability, and multiuser skills.

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

Expand all | Collapse all

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.

Properties

Article ID: 229755 - Last Review: June 28, 2004 - Revision: 2.0
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbbug kbpending KB229755

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com