Problem solved - the table has some 45 fields and the rs.delete will be doing something like delete field1, field2, field3, field4 etc etc.. so tried this and it works!
strSQL = "delete from table where intPrimary = 1"
db.execute strSQL
Thanks