Is it possible hide some code statements?

[accesser2003]

I want to hide some code statements so it is not be shown for the person who have the source code or the mdb file. At the same time I dont want this to have any affect on the execution of these hidden statements of code.

Is it possible to make this.

 

[pbaldy]

The simplest solution would be to distribute an mde instead of an mdb. Code would not be accessible.

 

[shadow9449]

I want to hide some code statements so it is not be shown for the person who have the source code or the mdb file. At the same time I dont want this to have any affect on the execution of these hidden statements of code.

Is it possible to make this.

1) Turn on your application

2) Press ALT + F11

3) Select Tools > Properties (whatever the name of your project is)

4) Click the Protection tab

5) Enter a password and click select "Lock project for viewing"

No one will be able to view the code.

SHADOW

 

[accesser2003]

Thanks Mr. Shadow, but what can I press ALT+11?

 

[shadow9449]

Thanks Mr. Shadow, but what can I press ALT+11?

Sorry, I meant ALT + F11.

Excuse the typo

SHADOW

 

[CraigDolphin]

Shadow, does that also prevent someone from importing the code modules etc to a new mdb file and viewing them there?

 

[shadow9449]

Shadow, does that also prevent someone from importing the code modules etc to a new mdb file and viewing them there?

It does.

Or exporting forms with code modules.

Or importing forms with code modules.

SHADOW

 

[CraigDolphin]

Cool Thanks for the info Shadow

 

[shadow9449]

Cool Thanks for the info Shadow

You're welcome

SHADOW

 

[Banana]

A note to keep in mind: Password-protecting the modules and converting it into MDE does not prevent someone from opening MDB/MDE with a text edit and still seeing all the variables names among other things. (The actual code such as If/Then/Else block won't be there, but can be guessed at).

 

[gemma-the-husky]

in an mde

you can still open all the queries, and see the table names/fields

that shouldnt be an issue though - commercial accounting packages etc dont exactly hide the file layouts form users - you can see pretty well everything via odbc links.

Banana, removing the code DOES make it very hard to modify/steal an app - most stuff has thousands of lines of code in it. it would be next to impossible to reconstruct this just by considering what the application appears to do