How to protect VB script in Db

[Steve in MN]

I saw a db where the programmer protected the code thru some type of coding.
where the program actually told me that it was not allowed to show it.
How does one go about it so that even if someone got behind the forms they
could not see the actual coding for the work.
is there a command that will run this or a series of language. The db that
i saw was well written and alot of bells and whistles but i dont know the
programmer to ask.
the db was not an MDA file it was a self contained mdb file.

 

[Paolo]

Hi Steve in MN,
to set user and group permissions on an mdb select the tools menu then
security and user and group permissions. There you can set the permissions on
the objects of your db and in particular deny the visualization of the code.

HTH Paolo

 

[Douglas J. Steele]

You can convert the MDB to an MDE and the code will not be accessible.

 

[Steve in MN]

I stumbled upon an option when i have the visual basic window open. In tools
menu, then project properties it has 2 tabs and the 2nd tab has an option to
lock the properties box and then below that it also asks for a user and
password to unlock.
Is this going to do the same thing? anyone ever use this option before? I
dont want to click and lock somthing if i dont know anything about it.

THanks.

 

[Douglas J. Steele]

Make a copy of your database and experiment on it.

 

[Steve in MN]

Finally got to try this tonight and yes, it does protect the code. It wont
prevent changes to the actual forms or reports, but unless you know the PW it
will not let you see the programming.
Kinda cool.