Access 2002 Office Links disabled; can't export to any format
Posted on 2004-04-16
I used to use the Office Links "Analyze it with Excel" function in Access 2002. I also used the "Export" feature to export reports to .XLS or HTML format.
Haven't used either function in a while, and today I needed to. The "Office Links" menu button is greyed out, and using the "Export" feature gets me this little gem:
<<The formats that enable you to output data as a Microsoft Excel, rich-text format, MS-DOS text, or HTML file are missing or incorrectly registered in the Windows Registry.
Run Setup to reinstall Name Of Database or, if you’re familiar with the settings in the registry, try to correct them yourself. For more information about the Registry, click Help.>>
Also, after selecting "Export", the "Export Report "Name of Report" to..." dialog appears, and the first File Type listed is "REGISTRY ERROR (*.*)". I can then scroll to select .XLS, HTML, etc.
Tried a repair of Office; no joy.
Tried removing and reinstalling Access; no joy.
I await enlightenment.