data

K

kawther

hello,
I have database having a column content a 9 digit number , each value in
the field is unique. . I need to send it to the database to external company
, so I need to do something with this column like encrypt or I have an idea
but I do not know how to do it; convert the numbers in the fields into
alphabetic such as

123456789 in qwertyuio

where I define the 1 as q, 2 as w and so on…

thank you in advance
 
D

Duane Hookom

Do you need to be able to decrypt it later? Would it be best to replace the
value with random characters?
 
K

kawther

thank you for your replay, yes i need to decrypt later, if you think that
random number will be better i will go for random number but it must be
unique value
 
D

Duane Hookom

I don't understand. If you need to decrypt the values later than random
wouldn't work. You might want to search google for "VBA encrypt".
 
J

John W. Vinson

hello,
I have database having a column content a 9 digit number , each value in
the field is unique. . I need to send it to the database to external company
, so I need to do something with this column like encrypt or I have an idea
but I do not know how to do it; convert the numbers in the fields into
alphabetic such as

123456789 in qwertyuio

where I define the 1 as q, 2 as w and so on…
Click to expand...

One question that might help Duane and the rest of us understand the question
better:

WHY?

What's the purpose of encoding this field?

If you want to keep the numbers private, such a trivial code won't stop anyone
who's interested in decrypting it.

John W. Vinson [MVP]
 
K

kawther

i have a huge records and this is colunm my company will like it to keep it
private and the same it the primary key and unique so i would like it to
replace it with encrypt value to send the databse to others companies
 
Top