Microsoft KB Archive/198931

= 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


 * Microsoft Access 2000 Standard Edition

-



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.



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.

