MS Access crashes on error -

i wrote little sql command correct field in table, since small (and maybe got little arrogant) didnt run once , put update package different user.

dim sql string dim rs dao.recordset on error goto errhandler   sql = "update table1 set name = 'calender' name = 'clalender'" currentdb.execute  errhandler: exit sub 

thats why didnt notice should have been

currentdb.execute (sql) 

when user startet command access said "critical error" , closed.

how come errorhandling didnt catch error? , why didnt access tell me there missing when wrote it? quite pedantic that.

thanks

the statement

currentdb.execute 

will not compile.

compile error: argument not optional.

your victim ;) must have hit error when tried run code, triggered "on-the-fly" compilation. error trapping in code not handle because code never got chance run (because wouldn't compile).

in other words, access would have gotten pedantic on if had tried run (or @ least compile) code.... :)