Protecting VBA Code

[Daniel P.]

Hello

Is there a way to password protect the VBA code behind a database to ensure that users don't modify it

Thanks in advance for your help

Daniel

 

[Nikos Yannacopoulos]

Daniel,

Even better! Convert your database to .mde (Tools > Database Utilities >
Make MDE file) and distribute the MDE. Your users will no longer be able to
view or modify your code, nor view forms, reports or macros in design mode
(and, consequently, make changes). What's more, the .mde file size will be
somewhat smaller than the original .mdb.
Just make sure you secure a copy of the original .mdb, so you can make
changes if required - which is impossible in the .mde.

HTH,
Nikos

Hello,

Is there a way to password protect the VBA code behind a database to

ensure that users don't modify it?

 

[Joe Fallon]

For newer versions of Access - 2000 and up I think:
In VBA,
Tools,
Properties,
Protection
--
Joe Fallon
Access MVP

Hello,

Is there a way to password protect the VBA code behind a database to

ensure that users don't modify it?