Encrypt data from a form into a table and back

M

Markus

Hallo

I hope some can help me I have a form where I am enter special type pin
numbers but I want the pin number to be encrypted and inserted into a SQL
table and I need to read the pin numbers out of the table again and decrypt
them. if any one has some code on how to do this it would be really a big
help


Regards
Markus.
 
M

Michel Walsh

Hi,


The easiest way would be to encode the database and define
users/workgroup security (both are under Tools | Security ). Encoding
avoid the data to be accessible by a program opening the mdb-file with a
file text editor in "clear" text, while security will avoid access to this
data, decoded, by opening the file from Access.

I strongly recommend you read the FAQ on security accessible from
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q165009


Hoping it may help,
Vanderghast, Access MVP
 
M

Markus

That is done already but the pins are located on a SQL server and as we all
know nothing is 100% secure even if the file is a MDE and the shift key is
off. so just to make it even hard for people to get to the pin number i want
them encrypted. it would be really a very greate help if some one could help
setup the code that i need.

Markus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Encrypte data into a table 5
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Encrypt data into table help please 0
Create a chart from a table in word thats dynamic 0
Help creating a search form in Access XP 0
Delete all data after a symbol in a field 0
Creating a Search using a combo box and then creating a report. 4
Insert Index into a Table 1

Top