Scramble/Randomize ID Numbers

Scramble/Randomize ID Numbers

Post by VHdlZ » Fri, 18 Apr 2008 04:56:03

Hi everyone,

I'm a new poster to this forum and hope that I'm not asking too basic of a
question. I have a database with identification numbers that I'd like to
scramble as I'm sending it out an outside source and would need to do this as
an extra measure of security.

The ID numbers vary in length, some are alphanumeric and some are not, and
if I could just figure how to do this as well as be able to "go back" to
figure out what the original IDs were, I could stop pulling out my hair.

Any help you can offer will be greatly appreciated...Going bald soon.

Many thanks,

Scramble/Randomize ID Numbers

Post by S2xhdHV » Fri, 18 Apr 2008 05:15:07

Assuming the ID numbers are unique, I would suggest a table to cross
reference the real ID with the madeup ID.
Take a look an the Randomize and the Rnd functions in VBA Help. You could
write some code to generate a false ID to send, and save the real ID in one
field of your new table and the corresponding false ID in the other.
Dave Hargis, Microsoft Access MVP