How do I re-write my query so that it will decode the masked files.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

petejk@gmail.com - 28 Mar 2006 20:24 GMT

I have select statement that is pulling up 'masked' password fields.
How do I re-write my query so that it will decode these masked fields.

Thanks

Reply to this Message

[MVP] S.Clark - 29 Mar 2006 20:02 GMT

I'm not sure if top secret's like these should be given across these
internets...
but, there used to be a little trick involving a UNION query. I won't get
anymore specific than that.

Signature

Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

>I have select statement that is pulling up 'masked' password fields.
> How do I re-write my query so that it will decode these masked fields.
>
> Thanks

Reply to this Message

petejk@gmail.com - 03 Apr 2006 06:52 GMT

This is what I did to view it.

I wrote a ultra basic app in C# and ran a SELECT against the table I
wanted.
All 'password' flagged fields came back as plain text.

Now all the world has an alternative for this type of situation.

Reply to this Message