2002-3 mde in 2007 environment

[Simon]

I have deployed a 2002-3 mde which was created in A2003.
2 of our people now have A2007.
There is a custom toolbar allowing users to print or export reports.
If they print a report with a chart in it the chart doesn't print.
If they click export they get an error message saying "You tried to perform
an operation involving a function or feature that was not installed in this
version".
I have scoured this forum and can't find anything.
Does anyone know what I need to do?
I have already downloaded the snapshot viewer for the 2007 users but I still
have the problem. Thank you.

 

[Arvin Meyer [MVP]]

Try putting the apps in a Trusted Location which is not enabled by default.
Check out the help files and this Knowledge Base article:

http://support.microsoft.com/kb/924738/en-us

Some of the export functionality to Excel has been eliminated, but the data
itself is still exportable.

 

[Simon]

Thanks for your swift response Arvin.
Unfortunately I still can't get it to work.
The "Disable all Trusted Locations..." was already unchecked and I've tried
various permatations but none have worked.
I have also tried creating a trusted location and placing the MDE and BE in
it but it still didn't work.
I have also created a test report in the BE using the Report Wizard and that
worked. (I obviously cannot try this in the front end as it is an MDE).
Do you have any other ideas?
Thank you again.

 

[Guest]

When 2007 was installed, was the chart component installed?

First check that you can create a new form with a chart
in 2007 on that computer!

Do you have a reference to the chart object in your
references? If so, you can get rid of it and fix any code
that requires it. The reference is not needed for the forms,
it is only a type library which enables you to use the
names of the predefined constants, and help you with
auto-completion while you are writing code.

(david)

 

[Simon]

David, Thanks for the reply.
I've created a report using the wizard and then a chart within the report -
all worked fine.
I'm sorry but I don't understand the references question but the mde works
fine if the user is running 2003.
Any further assistance would be greatly appreciated.

 

[Simon]

After much searching I'm half way to finding the answer, I think, so have
posted it for other users. It appears to be a fault in 2007 and there is a
hotfix available at
http://support.microsoft.com/kb/956054
Having said this it says it requires a password to operate, but when I enter
the provided password it fails with error 40? If I don't enter a password and
click skip it says its done but the feature still doesn't work. I will repost
if I get any further.

 

[Jason]

I recently upgraded to access 2007 from 2003. I have limited knowlege on
access and I use it only to gather data from two seperate sources, combine
this data, and output it to an excel file. In 2003 I could right click on a
report and output it to an excel file. In 2007 when I do that the excel
option is blanked out.

In searching for an answer to my problem I found the following article and
this particular comment stood out "Some of the export functionality to Excel
has been eliminated, but the data itself is still exportable." What does
this mean? How then can I export it? I'm about to tell our IT guy to
re-install 2003! Please help.

 

[Jeff Boyce]

Jason

Several of the users of one of the applications I built and support insisted
that the (new, A2007) application had to be able to "export to Excel" ...
and I'm still not aware of a 'fix' from Microsoft that allows this. I've
noted in the newsgroups that this functionality may not be returned
(something about lawsuit and settlement and such).

That said, I had to come up with a way my users could still "export to
Excel". Since the data can go (but the report cannot), I created the
functionality that allows the users to pick a report (that they would have
exported), then click an <Export to Excel> command button which uses the
query that would have fed the report they selected, and exports the data
from that query.

(... and yes, it sure would have been easier to just re-install A03, but the
IT folks here were NOT going backwards)

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jason]

Thanks, I may just re-install 2003.

Jason

Several of the users of one of the applications I built and support insisted
that the (new, A2007) application had to be able to "export to Excel" ...
and I'm still not aware of a 'fix' from Microsoft that allows this. I've
noted in the newsgroups that this functionality may not be returned
(something about lawsuit and settlement and such).

That said, I had to come up with a way my users could still "export to
Excel". Since the data can go (but the report cannot), I created the
functionality that allows the users to pick a report (that they would have
exported), then click an <Export to Excel> command button which uses the
query that would have fed the report they selected, and exports the data
from that query.

(... and yes, it sure would have been easier to just re-install A03, but the
IT folks here were NOT going backwards)

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jason]

Jeff - on second thought - how exactly do I do it? Do you have a program
that you wrote that I could buy, or do you have an easy way to walk me
through it? Any help would be appreciated. Thanks

 

[Jeff Boyce]

Jason

The application in which I use this approach was developed for/under my day
job, so it isn't for sale.

The "how" really depends on your specific situation. There isn't a simple
walk-through because your data and form setup would need to exactly match
the application.

Count this one as 'bigger than a breadbox' ... plan on it taking some time.

Regards

Jeff Boyce
Microsoft Office/Access MVP