Microsoft KB Archive/166352

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:32, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Article ID: 166352

Article Last Modified on 1/19/2007


  • Microsoft Access 97 Standard Edition

This article was previously published under Q166352

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


You cannot use external data with the AccessLinks add-in.


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.


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 kbprb KB166352