Knowledge Base

ACC2000: Can't Start Form Wizard in MS Excel on MS Query Data

Article ID: 198931

Article Last Modified on 6/29/2004

APPLIES TO

This article was previously published under Q198931
Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

When you try to create a Microsoft Access form in Microsoft Excel by using the Access Links add-in program, and you are using data from a Microsoft Query data source, you may receive the following error message:
Cannot start Microsoft Access form or report wizard.

CAUSE

You cannot use external data with the Access Links add-in.

RESOLUTION

When you create Microsoft Access forms in Microsoft Excel by using the Access Links add-in program, use only internal data for your data source.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open Microsoft Excel and be sure Microsoft Query has been installed.
  2. On the Data menu, point to Get External Data, and then click New Database Query.
  3. In the Choose Data Source box, on the Databases tab, select MS Access Database*, and then click OK.
  4. In the Select Database box, find the sample database Northwind.mdb in the Directories folder. Click OK.
  5. Add a few fields from the Customers table to Columns in your query, and then click Next three times.
  6. Click Return Data to Microsoft Excel to select it, and then click Finish.
  7. In Returning External Data to Microsoft Excel, accept the default Existing Worksheet, and then click OK.
  8. Save the workbook as Book1.
  9. On the Data menu, click MS Access Form and click OK. Note that you receive the error message mentioned in the "Symptoms" section.
NOTE: If the MS Access Form command does not appear on the Data menu, on the Tools menu, click Add-Ins, and then click to select the Access Links check box. Click OK.

REFERENCES

For more information about the Access Links add-in, click Microsoft Excel Help on the Help menu, type Create a Microsoft Access form for a Microsoft Excel list in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Additional query words: prb can t cannot

Keywords: kberrmsg kbprb KB198931


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.