Protecting VBA Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

Daniel P. said:
Hello,

Is there a way to password protect the VBA code behind a database to
Click to expand...
ensure that users don't modify it?
 
For newer versions of Access - 2000 and up I think:
In VBA,
Tools,
Properties,
Protection
--
Joe Fallon
Access MVP



Daniel P. said:
Hello,

Is there a way to password protect the VBA code behind a database to
Click to expand...
ensure that users don't modify it?
 
Back
Top