Modify MDE Report Programatically?

  • Thread starter Thread starter DDJ
  • Start date Start date
D

DDJ

We're considering distributing an Access MDE file with our app largely
because we want to avoid some of the security issues associated with
distributing and MDB file.

Is it possible to modify a report design in code (VB6) for an MDE file? I
know one of the benefits (to us) of the MDE is that the user can't modify
report design, but we really need to be able to modify the design "on the
fly" in code.

Thanks!

Dan
 
That kind of puts a damper on using the MDE then. Since we can't predict
user design preferences, we would then need to run code changing the design
every time the user prints or previews a report. From what I have seen, the
code required to modify the design adds a significant "hit" timewise to
processing those reports. I'll have to revisit this...

Thanks, Duane!

Dan
 
in message:
That kind of puts a damper on using the MDE then. Since we can't predict
user design preferences, we would then need to run code changing the design
every time the user prints or previews a report. From what I have seen, the
code required to modify the design adds a significant "hit" timewise to
processing those reports. I'll have to revisit this...
Click to expand...

You might find Armen Stein's download here quite interesting:

http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

Look for the last download file titled "Customizable Reports."

This gives the impression of user-created reports.
Perhaps you could incorporate something like this into your application.
 
DDJ said:
We're considering distributing an Access MDE file with our app largely
because we want to avoid some of the security issues associated with
distributing and MDB file.

Is it possible to modify a report design in code (VB6) for an MDE
file? I know one of the benefits (to us) of the MDE is that the user
can't modify report design, but we really need to be able to modify
the design "on the fly" in code.

Thanks!

Dan
Click to expand...


www.mantuanet.it/alessandro.baraldi sez. reports 2.0
resolve brilliantly your problem

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it
 
Not sure I understand what you mean here. Do you mean create the reports in
an MDB file where you can progamatically modify the reports design (and have
these changes saved) while setting up the MDE with linked reports (I didn't
think you could do that). Open the MDE from the app, and run the report??
Interesting.
 
Yes I have seen several solutions where the reports are in a separate mdb
file, so that the output from the system can be modified without disturbing
the main mde/mdb file. And what you do is this

automate the Access mdb from the MDE file, this will allow you to have
custom reports without messing with the MDE file.

http://support.microsoft.com/?kbid=210132
 
Back
Top