Hiding VBA Code

Paula222 · February 10th, 2006, 04:28 PM

How can i hide code in access 2003 vba , that if i send it to someone - he can't see the code ?

Paula.

rgerald · February 10th, 2006, 04:54 PM

Save the database as an .mde file. After that, the VBA cannot be seen or changed.

Rand

rgerald · February 10th, 2006, 05:09 PM

In my Access 2000:

Toolbar Menu:
Tools
Database Utilities
Make MDE file ...

Make certain to keep the original .mdb file, otherwise you will never be able to update the code.

Rand

Paula222 · February 11th, 2006, 06:14 AM

It works , Thanks!