Hello,
After the immediate reply from the foxweb team (thanks a lot) I have tried to simply connect to my sql server (in my case Mysql) and created a cursor in order to get the user table and it works perfectly :
mysql= SQLSTRINGCONNECT('dsn=mysql;uid=youruser;pwd=yourpassword')
SQLEXEC(mysql,"select name,password from usertable","users")
Auth.AuthTable = "users"
Auth.AuthformFile="AuthForm.fwx"
Auth.Useridfieldname="name"
Auth.Passwordfieldname="password"
Auth.SaveCookie = 1
Auth.Authenticate()
Simple as that !
JC