Dear Sir,

Your command does not work, I try to use following command

public myconnection
myconnection = sqlstringconnect("Driver={Microsoft Access Driver (*.mdb)};Dbq=e:\asoft\db1;Uid=admin;Pwd=")

lcSQL = ("Update Table1 SET sno=?THISFORM.text1.Value")
IF SQLEXEC(myconnection, lcSQL, 'table1') < 0
    AERROR(laError)
    MessageBox(laError[1,2])
ENDIF

This also does not work
Please help again