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:
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
- In Control Panel, create an ODBC data source to the Northwind database.
- 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.
- On the Data menu, point to Get External Data, and then click Create New Query.
- Select your data source and click OK.
- Add a few fields from the Customers table to "Columns in your query," and then click Next 3 times.
- Click "Return Data to Microsoft Excel" to select it, and then click Finish.
- In "Returning External Data to Microsoft Excel", accept the default Existing Worksheet, and then click OK.
- Save the workbook as Book1.
- 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 kbprb KB166352