In this post:
capricorn1 suggested looking at code in a previous post:
<see if the answer in this thread helps
Which I did. I grabbed the code and have been using it successfully. But now, I have users who have different regional settings, specifically Czech and Vietnamese.
When I change my settings to Czech, for example, and encrypt an IP address, then turn around immediately, while still in Czech, and decrypt it, the value I get back is not what I started with.
1. What am I missing?
2. What encryption code could I use in Access 2007 that will encrypt/decrypt successfully regardless of what the regional settings are?