Solved

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

Posted on 2004-04-16
4
516 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Some time ago I was asked to create a VBA function that would calculate a check digit for an input number, using the following procedure: First, sum up all the individual digits in the number If that sum value has more than one digit, then sum up …
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

912 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now