Hide VB code in FORM ...

[harshakusam]

Hi,

I designed a form and there is some VB code behid this.

When some one uses this FORM they can open this form in design view and also they can do some code changes .. so i dont want to allow .. is there any possibility to do this.

Cheers,
Harsha

[missinglinq]

Best would be to Compile the code and fix any errors, then goto

Tools - Database Utilities - Make MDE file

and make an MDE file. This prevents the users from making any design changes. Be absolutely sure to retain a copy of the MDB file! This will be needed to make modifications in the future; nothing can be changed in the MDE file!

Linq ;0)>

[NeoPa]

From the IDE (Alt-F11 from Access) select Tools / {project name} Properties.

From here select the Protection tab and you should find it straightforward from there.

[NeoPa]

As Linq says, an MDE file is another option which will certainly result in a protected project. It comes with other effects too though, so check it out and choose that which more closely fits your own particular needs.