Syntax error (missing operator) in query expression in VBA in MS Access -

Syntax error (missing operator) in query expression in VBA in MS Access -

i next error message: 3075 missing operator in query expression

here short snippet of code:

dim dbs database set dbs = currentdb() dbs.execute "delete temptable_entity_mapping_defset_selection;" while not rsdefset.eof debug.print rsdefset.fields.item("result").value mip = rsdefset.fields.item("fk_dim_mbr_item").value kpiname = rsdefset.fields.item("shortname_mbr").value id = rsdefset.fields.item("result").value defsetname = rsdefset.fields.item("kpi_defset_name") scenarios = rsdefset.fields.item("scenarios") filltemptab = "insert temptable_entity_mapping_defset_selection (mip, kpiname, id, defsetname, scenarios) values ('" & mip & "','" & kpiname & "','" & id & "','" & defsetname & "','" & scenarios & "');" debug.print filltemptab dbs.execute filltemptab rsdefset.movenext loop

looks you're missing want delete in sql statement

your first query should read

delete * temptable_entity_mapping_defset_selection;

vba ms-access access-vba