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

ID: Q166352

The information in this article applies to:

SYMPTOMS

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

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.


MORE INFORMATION

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.


  3. On the Data menu, point to Get External Data, and then click Create New Query.


  4. Select your data source and click OK.


  5. Add a few fields from the Customers table to "Columns in your query," and then click Next 3 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, run Setup to install the AccessLinks add-in.



REFERENCES

For more information about the AccessLinks feature in Microsoft Excel, search the Microsoft Excel Help Index for "AccessLinks add-in," and then "Convert a Microsoft Excel list to a Microsoft Access database." 


Keywords          : kberrmsg kbole IntpOlea 
Version           : 97
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: April 29, 1999