how to encrypt tables?

[argo]

i've tryed encrypt tables with ms access tools:
tools-security-encrypt/decrypt database but after i done this one,
i opened tables still can read not convered to ASCII code.
so how to secure table or to encrypt it?

 

[dcx693]

Encrypting a database using those command only encrypts the file itself so that the data contained within it cannot be read by using a simple text editor. It does nothing else in terms of security. In the absense of a database password or user-level security, anyone who can open the database has full access to the tables (and everything else).

If you need to secure the tables, investigate Access security.

 

[IgorB]

Create textbox Text1 on form bounded to your table field which contains some data.

Private Function Encrypt(sData As String) As String
Dim sTemp, sTemp1, tt As String
Dim ii As Integer
For ii = 1 To Len(sData)
sTemp = Mid(sData, ii, 1)
tt = Asc(sTemp) * 2
sTemp1 = sTemp1 & Chr(tt)
Next ii
Encrypt = sTemp1
End Function
-----------------------------------------
Example to call this function:
Text1=Encrypt(Text1)

 

[argo]

yes, that it what i want