Secure Database Code

[Pachydermitis]

Hi all you Access Experts,
I need to secure the code on a database that has a subform that changes
on the fly. I have tried everything I can think of.
-MDE: Can't change forms
-Put the form in a separate database and reference it: Can't figure out
how to place the referenced form in a subform.
-Put the code in a separate MDE and reference that: Can't use the class
modules.
-Put the code in an activex dll and reference it: Only class modules
are available.

At this point I could rework the database code to be entirely in
classes and then put them in an Activex dll, but I am looking 13,000
lines of code, each form would have to have it's event's watched, and
I'd have to separate all the functions used in queries.
Any Help would be appreciated
Thanks
Pachydermitis

[Rick Brandt]

Pachydermitis wrote:

Hi all you Access Experts,
I need to secure the code on a database that has a subform that
changes on the fly. I have tried everything I can think of.
-MDE: Can't change forms [snip]

Explain this part first. Design changes only require an MDB if you want to
make *permanent* changes to a form while in production use. If you just
need to alter properties of the form in certain circumstances that can
easily be done in an MDE. Those changes just are permanent lasting only for
that instance of the form being opened, but that should be sufficient.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Pachydermitis]

Rick,
Thanks for the reply. I actually need to create and remove controls.
Pachydermitis

[Pachydermitis]

Rick,
Thanks for the reply. I actually need to create and remove controls.
Pachydermitis