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

how to encrypt database

blossam
P: 29
i want to encrypt access database
using tools -? security -> encrypt/decrypt database option.
but its not working how to encrypt using this?
is there any setting require for encryption?
Sep 6 '07 #1
Share this Question
Share on Google+
5 Replies


ADezii
Expert 5K+
P: 8,669
i want to encrypt access database
using tools -? security -> encrypt/decrypt database option.
but its not working how to encrypt using this?
is there any setting require for encryption?
  1. Open Access but do not Open a specific Database.
  2. Tools ==> Security ==> Encrypt/Decrypt Database...
  3. Select database to Encrypt/Decrypt ==> OK.
  4. Enter a Name for the Database to be Encrypted/Decrypted ==> OK.
  5. The Encryption of the Database will be transparent to the User and you will so no noticeable changes except possibly slower execution times.
  6. I'm not really sure what you are expecting, but Encrypting a Database will simply prevent viewing of your data by 3rd party utilities such as Hex Editors, etc.
  7. Hope this helps.
Sep 9 '07 #2

blossam
P: 29
  1. Open Access but do not Open a specific Database.
  2. Tools ==> Security ==> Encrypt/Decrypt Database...
  3. Select database to Encrypt/Decrypt ==> OK.
  4. Enter a Name for the Database to be Encrypted/Decrypted ==> OK.
  5. The Encryption of the Database will be transparent to the User and you will so no noticeable changes except possibly slower execution times.
  6. I'm not really sure what you are expecting, but Encrypting a Database will simply prevent viewing of your data by 3rd party utilities such as Hex Editors, etc.
  7. Hope this helps.
thanks to help me but i dont want this.
i want any one can open my database but if thay open my database thay will find encrypted data. so , any one cant see what is in the database.
thay can just see structure and encrypted data.
Sep 10 '07 #3

ADezii
Expert 5K+
P: 8,669
thanks to help me but i dont want this.
i want any one can open my database but if thay open my database thay will find encrypted data. so , any one cant see what is in the database.
thay can just see structure and encrypted data.
Under this condition, you would have to capture all the existing data in the Database, run it through an Algorithm that will Encrypt it, store the data in its Encrypted state, Decrypt it when it come time for viewing the data, and make provisions for Encrypting all new data that will be entered. A 'lot' of overhead and a very challenging task for someone who is not that experienced. You are much better off creating a Security System for the DB, then assigning specific Permissions on the data for Groups of Users.

NOTE: I've posted a simple Encryption Algorithm below, if you are interested.
Expand|Select|Wrap|Line Numbers
  1. Public Function fEncryptString(TheString As String, ByVal nbrPlaces As Byte) As String
  2. '*******************************
  3. ' Author: Philfr               *
  4. '*******************************
  5. 'This is a simple Encryption Algorithm. Knowing all 'printable' characters are 8
  6. 'Bytes long, you can shift the bits to the left and still have a printable character.
  7. 'To Decrypt, all you have to do is to shift them left until you have come full circle
  8. 'as in the following calling procedures:
  9. 'to Encrypt: fEncryptString(TheString, nbrPlaces)
  10. 'to Decrypt: fEncryptString(TheString, 8 - nbrPlaces)
  11.  
  12. Dim tmp As Integer, i As Integer, mult As Integer
  13. Dim intLength As Integer, tmpSt As String
  14.  
  15. intLength = Len(TheString)
  16. tmpSt = ""
  17. nbrPlaces = nbrPlaces Mod 8     'no point doing more than 7, besides
  18. mult = 2 ^ nbrPlaces            'mult (an Integer) would be too small
  19.  
  20. For i = 1 To intLength
  21.   tmp = Asc(Mid$(TheString, i, 1))  'get the ASCII value of each character
  22.   tmp = tmp * mult                  'apply the multiplier
  23.   tmp = tmp Mod 256 + tmp \ 256     'rotate any 'carry' bit
  24.   tmpSt = tmpSt & Chr$(tmp)         'add the character to the String
  25. Next i
  26.  
  27. fEncryptString = tmpSt
  28. End Function
Sep 10 '07 #4

blossam
P: 29
Under this condition, you would have to capture all the existing data in the Database, run it through an Algorithm that will Encrypt it, store the data in its Encrypted state, Decrypt it when it come time for viewing the data, and make provisions for Encrypting all new data that will be entered. A 'lot' of overhead and a very challenging task for someone who is not that experienced. You are much better off creating a Security System for the DB, then assigning specific Permissions on the data for Groups of Users.

NOTE: I've posted a simple Encryption Algorithm below, if you are interested.
Expand|Select|Wrap|Line Numbers
  1. Public Function fEncryptString(TheString As String, ByVal nbrPlaces As Byte) As String
  2. '*******************************
  3. ' Author: Philfr               *
  4. '*******************************
  5. 'This is a simple Encryption Algorithm. Knowing all 'printable' characters are 8
  6. 'Bytes long, you can shift the bits to the left and still have a printable character.
  7. 'To Decrypt, all you have to do is to shift them left until you have come full circle
  8. 'as in the following calling procedures:
  9. 'to Encrypt: fEncryptString(TheString, nbrPlaces)
  10. 'to Decrypt: fEncryptString(TheString, 8 - nbrPlaces)
  11.  
  12. Dim tmp As Integer, i As Integer, mult As Integer
  13. Dim intLength As Integer, tmpSt As String
  14.  
  15. intLength = Len(TheString)
  16. tmpSt = ""
  17. nbrPlaces = nbrPlaces Mod 8     'no point doing more than 7, besides
  18. mult = 2 ^ nbrPlaces            'mult (an Integer) would be too small
  19.  
  20. For i = 1 To intLength
  21.   tmp = Asc(Mid$(TheString, i, 1))  'get the ASCII value of each character
  22.   tmp = tmp * mult                  'apply the multiplier
  23.   tmp = tmp Mod 256 + tmp \ 256     'rotate any 'carry' bit
  24.   tmpSt = tmpSt & Chr$(tmp)         'add the character to the String
  25. Next i
  26.  
  27. fEncryptString = tmpSt
  28. End Function
thanks
I also know some encryption algorithem but its not useful to me
'cus client req. that the system should enc. database. anyways i'll use some other database thanks lot.
Sep 12 '07 #5

P: 47
u wan to encrypt the data and will changing database help? if u want to encypt the data, u should look under system.security.cryptography(C#). there are a few types od encryption techniques..hashing actually like DES, MD5 and so on...
Oct 8 '07 #6

Post your reply

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