Solved

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

Posted on 2004-04-16
4
520 Views
Last Modified: 2010-08-05
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.
0
Comment
Question by:enkotec
  • 2
  • 2
4 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 10859577
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
 
LVL 1

Author Comment

by:enkotec
ID: 10860412
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
 
LVL 65

Expert Comment

by:rockiroads
ID: 10860683
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
 
LVL 1

Author Comment

by:enkotec
ID: 10860837
You're right.  Maybe our fearless administrator can link this over to the Access group.  :)
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question