data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Do you need to be able to decrypt it later? Would it be best to replace the
value with random characters?
 
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
 
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".
 
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]
 
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
 
Back
Top