Ok, it looks like i'm not opening the database like i thought i was. i guess i'll have to "line-by-line" it tomorrow. Man, i hate it when a computer does what i say instead of what i mean!

Code:
ERROR -2147352567 - COM exception error "update" (ADODB.Recordset - Operation is
 not allowed when the object is closed.) [-2147352567/80020009]

Thanks!
Dave