Michel,
Is the Number field in Access DB is in Number format or Character field? If The number(field) is Number You try to insert a String into Number

*** values ('00006534','03')
************ String    String
************
* May be when You generate the string You must not put "'" before & after myresult.number

lcsql = "insert into [otherissuer] (number,type) values ("
lcsql = lcsql + myresult.number+","
lcsql = lcsql + "'"+myresult.type+"')"