@Jaz: Coming from a VB6 background, you're doing it wrong. Smiley

 

For inserts you'll want to use the ADODB.Command object, not the Recordset. The Recordset is more like a DataTable, DataAdapter, and BindingSource all rolled into one.