Connecting Tech Pros Worldwide Forums | Help | Site Map

Hide VB code in FORM ...

Member
 
Join Date: Apr 2009
Posts: 36
#1: May 28 '09
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's Avatar
Moderator
 
Join Date: Nov 2006
Location: Richmond, Virginia USA
Posts: 3,103
#2: May 28 '09

re: Hide VB code in FORM ...


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's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 16,173
#3: May 28 '09

re: Hide VB code in FORM ...


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's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 16,173
#4: May 28 '09

re: Hide VB code in FORM ...


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