Error write and read from Registry VBA

[Zalo]

Hello everyone

I just test write and read RC4 string to registry via VBA
but it make error: string write and read from registry is different

In this image: when input string in "Message" and "Key"
then result:
A and B are different
C and D are different

Does anyone know why ?
Thanks in advance

 

[theDBguy]

Hi. Welcome to AWF!

Can't look at your file right now, but have you or are you using the following functions?

SaveSetting statement (VBA)

Office VBA reference topic

docs.microsoft.com

GetSetting function (Visual Basic for Applications)

Office VBA reference topic

docs.microsoft.com

 

[isladogs]

Ah. You seem to have got the RC4 code from me as I recognise the modification I made on 31/03/2020.
Please can you clarify what you would expect/want to happen. It seems correct to me.
A is the RC4 encryption of the message
B is the same from the registry
C is the decrypted version of the registry key
D is the decrypted version of A

So I would expect A & B to be the same and , separately C & D to be identical...which they are!

I got this result:

Also if you upload a database which modifies the registry, you need to be upfront about what change(s) were made.
Whilst I can read the code, you should be explicit about the changes made in this thread

EDIT - I see you've now edited the image in the first post. Pity the original was blank!

 

[Zalo]

To

theDBguy​

I do not use that functions.

 

[Zalo]

To isladogs

- RC4 code seem from Andreas J”nssonb
- I changed image in first post to make clear what i mean. When you input another complicate sample. it's not the same.

 

[isladogs]

The RC4 code was indeed originally written by Andreas J”nsson. I have used it without problems in multiple databases for at least 15 years.
The modification dated 31/03/2020 was made by me following a discussion with David Marten (cheekybuddha) to fix an array error in a thread here earlier this year. See https://www.access-programmers.co.u...r-for-text-strings.311866/page-2#post-1699024

For an example where I use it, see http://www.mendipdatasystems.co.uk/encrypted-split-no-strings-db/4594566347
EDIT: that link includes the unmodified version of the RC4 code. You can try that and see if it gives you the results you expect (and like those I got)