Code to Encrypt password not working

[lumiere]

Hi,



I am making a database for recording the transactions of a small shop.
As it would be used by different people, I decided to introduce a login form where different users have to enter their respective passwords for logging in.
After entering password, I thought it was better to encrypt the password.

I downloaded an encryption algorithm for vba from internet. The function takes in a string (password to be encrypted), a secret key and an Optional Boolean variable.
The algorithm seems to work if the Boolean is set to false but gives error on compiling if set to true.

I have attached a copy of a database with just the function of entering a password and its subsequent encryption.
I would be greatly thankful if someone has a look in it and help me to sort out the error.

The encryption algorithm was downloaded and imported as a seperate class. After downloading, I tried to run it but it was giving an error, so I added 'PtrSafe' in the Private Declaration line of the code.
The optional boolean variable I talked about seems to convert the encoded string to Unicode.
The error that occurs is the 'Compile Error : Type Mismatch' and VarPtr is highlightd. My machine is a 64-bit. I tried to look online for the solution and saw that Long should be replaced with LongPtr.
I tried that but that lead to a new 'Type mismatch' error, at some other part of the code.

I am not experienced in cryptography. Can someone please help me.

[CJ_London]

are you running 64 bit access? the bitness of the machine is irrelevant.

The implication of setting the boolean to true is that you are running 32bit access.

To check, go to File>Help - you should see the access bit size off to the right

[lumiere]

Thanks for the reply.

I am running 64 bit access.

So, if I run the code on 32-bit access, there would be no errors?

[isladogs]

I did a quick test earlier. There were still issues using 32-bit Access though in that bitness it does compile.
You do need to add the line Option Explicit to the form module and fix the compilation errors
For example, are you aware the CopyMemory API is listed twice in the class module?

Anyway, I found it almost unusable taking anything well over a minute to return an encrypted password and crashing repeatedly.

If you are interested I have an example database using 128-bit RC4 encryption for passwords
http://www.mendipdatasystems.co.uk/p...gin/4594469149

[lumiere]

I did a quick test earlier. There were still issues using 32-bit Access though in that bitness it does compile.
You do need to add the line Option Explicit to the form module and fix the compilation errors
For example, are you aware the CopyMemory API is listed twice in the class module?

Anyway, I found it almost unusable taking anything well over a minute to return an encrypted password and crashing repeatedly.

If you are interested I have an example database using 128-bit RC4 encryption for passwords
http://www.mendipdatasystems.co.uk/p...gin/4594469149

Thanks for your input and sorry for such delay in response from my end.

I copied the class code from a website. And I noticed CopyMemory was listed twice.
I tried the above code on a number of systems and some of them have quite slow responses, some of them ranging in order of minutes. So I guess the code is unusable for practical purposes. I have looked at RC4 encryption module and it is quite intriguing.
I wanted to ask, is it open source and can be used by anyone?

However I want to mention that I succeeded in converting my original code to be usable for 64-bit
systems. I had to change some 'long' to 'longptr' in CopyMemory statement and some others to
'longlong'.
I will share the class if anyone's intrested.
Thanks.

[isladogs]

RC4 encryption is freely available and is open source. Its also very fast, reliable and works in both 32/64-bit!

For info, you should never need to use LongLong when converting API code