I need a complete overview on the steps necessary to secure a
distributed application built using Access XP.
The app consists of the main .mdb containing all of the code, forms,
queries ect, and various other mdb's that contain only tables and are
linked to the main mdb. The application will be distributed to any
number of clients running anything from W98 to XP, using the access
runtime.
My goals are at a minimum the following: 
    Protect my prospective client’s data 
    Protect my app from being modified 
    Protect my code and form's from being viewed 
I have already implemented encryption to prevent non access programs
from viewing the data.
What I need here is a complete but general overview to the steps
involved in totally securing the application. I will then ask further
questions based on what I don’t understand and compensate by tipping
or just creating new questions.
Something worth mentioning is that I need the security to be totally
100% transparent to the user (since the program has it’s own built in
security for limiting access to functions within the app) and I need
the solution to be either pre built, implemented through code or
carried out by an installation program at the time of install, since I
can not administer security to every person who buys this software.
Thanks, 
Brian

Brian,

If you're kicking the price up because you think I'm ignoring you,
that's not the case. I simply don't feel that I can provide you with a
soup-to-nuts answer to your question. I know how to do part of what
you need, but not all of it. I'm also not sure what all the "gotchas"
are with the parts I do know about. Access security is something of a
black art, especially in a distribution environment.

- Hammer

Hey Hammer,
I totally didn't think you were ignoring me :->. I just like to put
these up here without an 'attention to you' because I don't want to
obligate you into answering if you don't think it's worth it. That is
of course unless I know I need your expertise right away, in which
case you can expect it addressed specifically to you. :->
Either way, I didn't get any bites so I figured I'd sweeten the pot a
little. If no one has a complete answer than I will take what you have
and go from there. Give it a little while longer and see if any one
else wants to field the question, if not then we'll go with what
you've got.
Thanks as always,
Brian

OK! BTW, I notice that the progress meter question is still open. How
did that sample mdb work out for you?
http://answers.google.com/answers/main?cmd=threadview&id=175223

- Hammer

Brian,

I don;t see anyone picking this up so...

Do you already know about compiling your project as an MDE?

- Hammer

Hammer,
yes - actually I am in the process of making some design changes in
our code to allow this to happen.
I think I will close this question and see what we can figure out on
our own and with the help of some security software vendors we have
found. If I don't get anywhere I will repost more specific questions
as I run into problems.
I'll talk to you soon :->
Brian