how to encrypt database

[blossam]

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?

[ADezii]

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.

[blossam]

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.

[ADezii]

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.

Public Function fEncryptString(TheString As String, ByVal nbrPlaces As Byte) As String
'*******************************
' Author: Philfr               *
'*******************************
'This is a simple Encryption Algorithm. Knowing all 'printable' characters are 8
'Bytes long, you can shift the bits to the left and still have a printable character.
'To Decrypt, all you have to do is to shift them left until you have come full circle
'as in the following calling procedures:
'to Encrypt: fEncryptString(TheString, nbrPlaces)
'to Decrypt: fEncryptString(TheString, 8 - nbrPlaces)
 
Dim tmp As Integer, i As Integer, mult As Integer
Dim intLength As Integer, tmpSt As String
 
intLength = Len(TheString)
tmpSt = ""
nbrPlaces = nbrPlaces Mod 8     'no point doing more than 7, besides
mult = 2 ^ nbrPlaces            'mult (an Integer) would be too small
 
For i = 1 To intLength
  tmp = Asc(Mid$(TheString, i, 1))  'get the ASCII value of each character
  tmp = tmp * mult                  'apply the multiplier
  tmp = tmp Mod 256 + tmp \ 256     'rotate any 'carry' bit
  tmpSt = tmpSt & Chr$(tmp)         'add the character to the String
Next i
 
fEncryptString = tmpSt
End Function

[blossam]

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.

Public Function fEncryptString(TheString As String, ByVal nbrPlaces As Byte) As String
'*******************************
' Author: Philfr               *
'*******************************
'This is a simple Encryption Algorithm. Knowing all 'printable' characters are 8
'Bytes long, you can shift the bits to the left and still have a printable character.
'To Decrypt, all you have to do is to shift them left until you have come full circle
'as in the following calling procedures:
'to Encrypt: fEncryptString(TheString, nbrPlaces)
'to Decrypt: fEncryptString(TheString, 8 - nbrPlaces)
 
Dim tmp As Integer, i As Integer, mult As Integer
Dim intLength As Integer, tmpSt As String
 
intLength = Len(TheString)
tmpSt = ""
nbrPlaces = nbrPlaces Mod 8     'no point doing more than 7, besides
mult = 2 ^ nbrPlaces            'mult (an Integer) would be too small
 
For i = 1 To intLength
  tmp = Asc(Mid$(TheString, i, 1))  'get the ASCII value of each character
  tmp = tmp * mult                  'apply the multiplier
  tmp = tmp Mod 256 + tmp \ 256     'rotate any 'carry' bit
  tmpSt = tmpSt & Chr$(tmp)         'add the character to the String
Next i
 
fEncryptString = tmpSt
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.

[wassssup]

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...