Encryption via VBA Code

I'm building an application to create a number of piece of similar software
(same forms and code, with data imported from a variety of similar external
databases) for distribution to a an assortment of clients. The data for each
piece of software created needs to be protected by encryption with its own
unique password. I want to end up with (a) separate encrypted
distributable software (as an .mde) for each client and (b) a control and
distribution application with a table of clients and a related table of
software by client, with passwords. Creation of the control software and the
software to be distributed and importing the related tables are no problem,
and the generation of unique passwords is easy, but how, from within the
control application using VBA code, can I encrypt each database to be
distributed and assign the password. I'd like the process to be transparent
if possible.

Hope someone has an answer ... many thanks

Bob Boyden

--
Message posted via http://www.accessmonster.com

re: Encryption via VBA Code

On Fri, 16 Jun 2006 21:33:10 GMT, "rwboyden via AccessMonster.com"
<u12496@uwe> wrote:

Use precise language. "Encrypt" means something very specific in
Access (Tools > Security > Encode) and it doesn't require a password.

You can set a database password (Tools > Security > Set Database
Password), but many resources say it's a joke.

You can use Access security (study the FAQ!), but it also can be
cracked.

What do you mean by "encrypted software"?

-Tom.


[color=blue]
>I'm building an application to create a number of piece of similar software
>(same forms and code, with data imported from a variety of similar external
>databases) for distribution to a an assortment of clients. The data for each
>piece of software created needs to be protected by encryption with its own
>unique password. I want to end up with (a) separate encrypted
>distributable software (as an .mde) for each client and (b) a control and
>distribution application with a table of clients and a related table of
>software by client, with passwords. Creation of the control software and the
>software to be distributed and importing the related tables are no problem,
>and the generation of unique passwords is easy, but how, from within the
>control application using VBA code, can I encrypt each database to be
>distributed and assign the password. I'd like the process to be transparent
>if possible.
>
>Hope someone has an answer ... many thanks
>
>Bob Boyden[/color]