Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Passwoar encryption within MSAccess??


cypher23

Recommended Posts

Posted

hello,

perphaps someone can help me or give a hint.

i have big problems connecting to my shop over phpmyadmin or mycontrolcenter. i do all the products-updating with ms access local and then upload the databases via ftp. know the problem is: can i "update" the costumers-passwords within access to??

 

i tried out this:

 

 

update customers set customers_password = concat_ws(":", md5(concat('ip', customers_password)), 'ip');

from

"http://www.oscommerce.com/forums/viewtopic.php...import+customer"

 

 

it works fine in sql but does someone know how i can do it with access?

 

thanks for the help.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...