How to encrypting code in access 2003

[Alias90]

Hi everybody!
My proplem is how to encrypting code in acess 2003. my project has been locked by password. When users login , after 3 wrong times , project will have been encrypted automaticly .After encryption,Alth ough we type right password, project hasn't restored code.Because my project is
secret. I hope i will gived answers soon. Thanks U!!

[Rabbit]

I'm not sure what you're asking for because it sounds like you're already getting the behavior you want.

[Alias90]

it means :
ex:
my code:

me.textbox1=count
 me.testbox1.Requery

after encrypted :absdszoechdhsi s or 34446744556423 ....,etc.

[Rabbit]

I still don't understand, so you've encrypted it, now what?

[Alias90]

my Eng is not good.I'm sorry!
1st. when users open "secret.mdb ". Users have to login by password.
2nd.If project is counted Wrong password 3 times, code in VBA have encrypted.
code vba: example:

txtabc=""
txtdef.requery

after encrypted:
it can change any characters. ex:

txtabc=""= adsadnadnngfnwef or ******* ,etc..
txtdef.requery=adsadnadnngfnwef or ******* ,etc..

I need a funtion to encrypted code in VBA.That's all
Thank Rabbit so much

[zmbd]

Alias90:

Are you trying to encypt the VBA code or are you trying to encrypt the records in the data tables?

[Rabbit]

Just create a compiled version and distribute that while you hold onto the uncompiled version. That way no one but you can see the source without the need for encrypted code.

On a side note, you would never want to encrypt after failed attempts. You should keep it encrypted and unencrypt only after someone enters the correct password.

[Alias90]

Dear Rabbit!!!
The code VBA is keep encrypting although someone trys to enter the correct password.

[Rabbit]

That not what you said earlier.

Like I said though, no need to encrypt the code, just distribute a compiled version.

[Alias90]

So i still want to encrypt code.Sorry!! i can't understand "Like I said though, no need to encrypt the code, just distribute a compiled version." I hope U can help me more clearly. I'm newbie

[zmbd]

1) Make your front end or application as you want it to work.
2) Comple your code in the VBA editor via the debug compile.
3) Close the database
4) Make a copy of the database, once the MDE is made it's difficult to undo.
5) Open the COPY of the database
6) From the menu: Tools \ Database Utilities \ Make MDE File