OT - I need some help with Access

[TuffGuy]

I need to encrypt the CC #s in our database. How would I update 1234567890 to *******890? Would I use an update query, and what wildcards/values would I use? Thanks for the help.

 

[conjur]

What version of Access and what OS version?

You might consider using the Crypto API. I could send you a VB6 module that I use (forgot from where I got it but it works well) for my COM objects to encrypt SQL user passwords.

 

[TuffGuy]

It's Office XP and Win2k. There should be a way to run a quick update query using some wildcards, but I don't know Access that well. 🙁

 

[conjur]

Well, if you just want to mask the first 8 characters:

UPDATE table
SET column = '********' + Right(column, 4)
WHERE (column is not null) AND
(Len(column) = 12))

Assuming you're storing a validated 12-character CC# in a char column.

 

[TuffGuy]

🙂 thank you!