>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