Password Protection for Distributed VBA Module - MS Access

[kcolemanSLU]

Hello!

Total newbie to this forum so please bare with me as I attempt to make my first post.

A little background on my project... I work on a University campus which uses Access. I've written a module that I'd like to distribute to most users on campus - and while I don't want them to be able to access the code and "fiddle" with it (not for security reasons), I would like to be able to easily distribute it.

Is there a way to protect the module while still allowing it to be distributed through the normal import/export?

Thanks!

Kimberly

 

[kcolemanSLU]

I think I see now, I have to open the module and enter the password and then I can export it to the other database.

Does anyone have suggestions for a simpler way to do what I want?