Report writer for end user

[Clifford Zivi]

I want to package an application that will allow the end
user to write their own ad-hoc reports; like format their
own invoices. I believe that the Report Wizard is not
available in an MDE file. If I distribute an MDB file
then my code will be accessable. How else can this be
accomplished?

 

[Arvin Meyer]

I want to package an application that will allow the end
user to write their own ad-hoc reports; like format their
own invoices. I believe that the Report Wizard is not
available in an MDE file. If I distribute an MDB file
then my code will be accessable. How else can this be
accomplished?

You can secure the application and not give design rights to existing
objects. Have a look at the security FAQ:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Larry Linson]

And, in addition to what Arvin suggests, you can package your code in an MDE
that you include with your MDB as a library, from which you call functions.

Just be aware that no security is foolproof, nor impregnable.

Larry Linson
Microsoft Access MVP