By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,124 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

How to encrypting code in access 2003

Alias90
P: 23
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,Although we type right password, project hasn't restored code.Because my project is
secret. I hope i will gived answers soon. Thanks U!!
Sep 21 '12 #1

✓ answered by 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

Share this Question
Share on Google+
10 Replies


Rabbit
Expert Mod 10K+
P: 12,315
I'm not sure what you're asking for because it sounds like you're already getting the behavior you want.
Sep 21 '12 #2

Alias90
P: 23
it means :
ex:
my code:
Expand|Select|Wrap|Line Numbers
  1. me.textbox1=count
  2.  me.testbox1.Requery
after encrypted :absdszoechdhsis or 34446744556423 ....,etc.
Sep 21 '12 #3

Rabbit
Expert Mod 10K+
P: 12,315
I still don't understand, so you've encrypted it, now what?
Sep 21 '12 #4

Alias90
P: 23
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:
Expand|Select|Wrap|Line Numbers
  1. txtabc=""
  2. txtdef.requery
after encrypted:
it can change any characters. ex:
Expand|Select|Wrap|Line Numbers
  1. txtabc=""= adsadnadnngfnwef or ******* ,etc..
  2. txtdef.requery=adsadnadnngfnwef or ******* ,etc..
I need a funtion to encrypted code in VBA.That's all
Thank Rabbit so much
Sep 21 '12 #5

zmbd
Expert Mod 5K+
P: 5,287
Alias90:

Are you trying to encypt the VBA code or are you trying to encrypt the records in the data tables?
Sep 21 '12 #6

Rabbit
Expert Mod 10K+
P: 12,315
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.
Sep 21 '12 #7

Alias90
P: 23
Dear Rabbit!!!
The code VBA is keep encrypting although someone trys to enter the correct password.
Sep 24 '12 #8

Rabbit
Expert Mod 10K+
P: 12,315
That not what you said earlier.

Like I said though, no need to encrypt the code, just distribute a compiled version.
Sep 24 '12 #9

Alias90
P: 23
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
Sep 24 '12 #10

zmbd
Expert Mod 5K+
P: 5,287
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
Sep 24 '12 #11

Post your reply

Sign in to post your reply or Sign up for a free account.