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

• Microsoft Access 2000

SYMPTOMS

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

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.

MORE INFORMATION

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.

REFERENCES

For more information about the Acces Links add-in, click Microsoft Excel Help on the Help menu, type "Create a Microsoft Access form for a Microsoft Excel list" in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Additional query words: prb

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