Error trying to export from an older access database(using Access 2007) to excel spreadsheet

We have an older access database (2000/2003 not sure) and a computer with office 2007.  When we try to use the export function from this PC we get the following error:
"The format in which you are attempting to output the current object is not available"  Either you are attempting to output the current object to a format that is not valid for its object type, or the formats that enable you to output data as a microsoft excel, rich text format, ms dos text, or html file are missing from the windows registry.  Run setup to reinstall ms office access or, if you are familiar with the settings in the registry, try to correct them yourself."
Then after we click OK, we get the following dialog box from Access:
ACTION FAILED:
Macro Name:  ExportToExcel
Condition: True
Action Name: OutputTo
Arguments: 1, ComboSearchResults, MicrosoftExcel(*.xls), N:\AeroDocs\Aero Design Documents\Technical Documents\Tech Database\DB_Results.xls, Yes, , ,

Error # 2950

We are using office 2003 on all other PCs and are experiencing NO problems.  Is this a macro issue or is there something missing from this version of Access 2007 professional which we need to install or reinstall?

PS This is a closed application - I do not know where to find the macro to show the code.
Marshall KassOwnerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
Is the machine having the problem at the same Service Pack level asa all the other machines? (for Office and Windows)
0
Marshall KassOwnerAuthor Commented:
this is the only PC we are running office 2007 on.  The others are running 2003 pro.  My customer purchased and installed this without my knowledge , we just ordered 5 more copies and he told me about this issue after the order was completed.  So no, it is the XP Pro SP3 but a different version of office.
0
Jeffrey CoachmanMIS LiasonCommented:

Try creating a Blank Access 2003 database *in Access 2003*.
Then importing all of the objects into it.
Then use this as the new standard db that all the computers run.

Then report back.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Gustav BrockCIOCommented:
Run the Office 2007 install again, select "Custom", and mark all relevant im- and export (data) formats for Access and Excel (- can't remember the exact options).

/gustav
0
Marshall KassOwnerAuthor Commented:
I actually found the solution in another of boaq2000's answers (http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24503876.html) and applied it here.  I split the points as you were both helping, and I appreciated your responses.
0
Jeffrey CoachmanMIS LiasonCommented:
<I actually found the solution in another of boaq2000's answers (http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24503876.html) and applied it here.>
Thanks.

I am gald to see that a previous solution of mine helped you.
;-)

Jeff
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.