Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2004-04-16
4
Medium Priority
?
527 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 2000 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

578 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