Microsoft KB Archive/166352

= ACC97: Cannot Start Form Wizard in Microsoft Excel on Data from Microsoft Query =

Article ID: 166352

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q166352



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you try to create a Microsoft Access form in Microsoft Excel by using the AccessLinks 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 AccessLinks add-in.



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



Steps to Reproduce Behavior

 * 1) In Control Panel, create an ODBC data source to the Northwind database.
 * 2) Open Microsoft Excel and be sure Microsoft Query has been installed.

NOTE: If you have installed Microsoft Excel from Microsoft Office 97 Professional Edition, you will need to choose the Data Access option to install Microsoft Query.
 * 1) On the Data menu, point to Get External Data, and then click Create New Query.
 * 2) Select your data source and click OK.
 * 3) Add a few fields from the Customers table to "Columns in your query," and then click Next 3 times.
 * 4) Click "Return Data to Microsoft Excel" to select it, and then click Finish.
 * 5) In "Returning External Data to Microsoft Excel", accept the default Existing Worksheet, and then click OK.
 * 6) Save the workbook as Book1.
 * 7) 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, run Setup to install the AccessLinks add-in.

