Hello,
I have question about an encrypted password field in an MSAccess
database file.
My task is to migrate a shopping cart from ASP/Access to PHP/MySQL...
which [both] is quite new territory for me!
Now, everything went smoothly so far: I exported the Access data into a
textfile, remodeled it to fit the new shopping cart data base and
imported it using phpMyAdmin...
The only problem is, of course and that's where my question comes in is
that MySQL and Access use different password encryption. and the
passwords that I "manually" imported into MySQL don't work for the
login (as they ar interpreted completely different).
As I understand MySQL uses MD5 to encrypt password fields, but what
does MS Access use ? The passwords look like this : F?-¦AŸ5 or
W?ž©^?5V or Q-?²S·5@Òúh (sorry, but I don't know how else to
describe it ;-) )
I figure, that once I know which algorithm is used, than I can look for
a conversion tool.
Am I completely off? Does anybody have any idea how I could tackle this
problem?
Thanks in advance!!!
Aji