Is there a way to encrypt the data that travels from the client end to the database. How would I open the recordset or set it up?
Currently this is how I do it:
conn.Open "Provider=sqloledb;Data Source=" & ConnectionIP & ",1433;Network Library=DBMSSOCN;Initial Catalog= *****; User ID=sa;Password=********"
rec.CursorLocation = adUseClient
rec.Open (esql), conn, adOpenStatic, adLockOptimistic