ms access compile modules / link to mde vba modules

Hi,

I have an MDB that has its VBA modules and code (lets call it main MDB). I have got another MDB with some VBA functions that i'd like to protect its code. (lets call it functions MDB) any ideas how to do it?

I guess i'm asking is it possible to either:
1. compile the functions MDB into an MDE, and then somehow to link the main MDB code into this new MDE...

2. to somehow compile or otherwise secure the code modules inside the functions MDE and then to export them to the MDB

is this possible somehow ?

Password protect the code modules in functions MDB from the VB editor Tools->Properties. Inside main MDB, open Tools->References from the VB editor. Click browse and select your functions db. You're done.

You don't have to compile it into an MDE.

VBA password is relatively easy to break. Compile into MDE is more secure.

Yes I know that VBA password is easy to break, but how can i compile into MDE and still call this MDE functions from another MDB ?

Thanks,

You need to add the mde file as a reference. In a code window goto: Tools > References. Then click browse and select your mde file.

One thing to consider if you are to deploy the the mdb to multiple users you need to make sure the mdb is in a network area they all can access.