If the connection is OK and the SQL query is returning a valid recordset object, then it may well be the $Recordset.AddNew() method that is failing... ...not sure why, though. MSDN says you can use the Supports() method to check whether your current Recordset object will support various methods, based on the cursor and lock types. You can check here for that. You'll need to look under ADO Reference -> ADO Methods.

I'm off home now, so I'll print this off and rack my tiny brain a little.

[ 05 February 2002: Message edited by: Breaker ]