Access 2002 Office Links disabled; can't export to any format

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.
LVL 1
enkotecAsked:
Who is Participating?
 
rockiroadsConnect With a Mentor Commented:
perhaps there is a problem with the Office installation?
dont know if fixing that would help - painful task so I dont blame you for not trying as this post is merely a suggestion
0
 
enkotecAuthor Commented:
I tried to uninstalling/reinstalling Access from the Office configuration/setup via Control Panel.  This had no effect.

Then I downloaded the Office XP Resource Kit, and used the Removal Wizard to remove Access.  I then rebooted and reinstalled Access.  This seems to have solved the problem - I can now export and use the Office Links as before.

I suspect this happened because I installed Office SP-3, then decided that some of the security features annoyed me and removed/reinstalled Office.  It would seem that the uninstall via Control Panel doesn't do the job completely.  The Removal Wizard in the ORK definitely did the trick.

Office XP Resource Kit can be found at http://www.microsoft.com/office/ork/xp/ 

Points to rockiroads for being the only responder.  Thanks!
0
 
rockiroadsCommented:
cheers man

perhaps you could also of placed this in MS Access group (this or new post redirecting to this with very low points)

but glad to see you got it working

good tip as well to know
0
 
enkotecAuthor Commented:
You're right.  Maybe our fearless administrator can link this over to the Access group.  :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.