Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

New style of hardware planning for Microsoft Exchange server.
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.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

916 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