Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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

↑ Back to the top


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.

↑ Back to the top


Cause

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

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


Keywords: KB198931, kbprb, kberrmsg

↑ Back to the top

Article Info
Article ID : 198931
Revision : 2
Created on : 6/29/2004
Published on : 6/29/2004
Exists online : False
Views : 267