473,320 Members | 2,003 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to encrypting code in access 2003

Alias90
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

10 2025
Rabbit
12,516 Expert Mod 8TB
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
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
12,516 Expert Mod 8TB
I still don't understand, so you've encrypted it, now what?
Sep 21 '12 #4
Alias90
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
5,501 Expert Mod 4TB
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
12,516 Expert Mod 8TB
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
23
Dear Rabbit!!!
The code VBA is keep encrypting although someone trys to enter the correct password.
Sep 24 '12 #8
Rabbit
12,516 Expert Mod 8TB
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
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
5,501 Expert Mod 4TB
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

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

Similar topics

13
by: Noesis Strategy | last post by:
When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles. Recently, I have begun to design Access databases using an copy of Access 2002 from my previous laptop. It works fine,...
1
by: pw | last post by:
Hi, I can't find anything about a toolkit on Microsoft site or what is needed to distribute an Access 2003 application (like the SDK w/ Access 97). I assume this is still possible. What do I...
13
by: Manuel Lopez | last post by:
I have a puzzling form timer problem that I didn't experience prior to Access 2003 (though I'm not sure access 2003 is to blame). Here's the situation: a computer has two access 2003 databases on...
5
by: j.mandala | last post by:
Someone is trying to run my Access 2002 database under Access 2003. He has had a number of problems: 1) i used the MSComCt2.ocx for it's Date and Time picker. I can't find it under 2003. Do I...
1
by: Matt Alanzo | last post by:
On another newsgroup an Access knowledgable party posted: >You should be able to connect an Access ADP to an existing SQLExpress >database running in SQLS 2000 compatibility mode. The only thing...
3
by: Mike Gramelspacher | last post by:
Hello, I have an Access 2000 database that I copied to a new computer with Access 2003. Access 2003 says the file is in Access 2000 file format. I made some changes to the Access 2000 file...
10
by: Lauren Wilson | last post by:
Ok I have searched the MS website for info on this. I am totally confused. If I want to deploy an Access 2003 app and allow my users to run it using Access 2003 Runtime, where do I get the...
1
by: i8mypnuts | last post by:
Could someone please help? I am using the 'defaultprt.zip' tool provided by Ken Getz to change the default printer via VBA code (code below). My problem is that once the default printer has been...
49
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code,...
17
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.