Nick;

I use a static recordset. Here is some of the code to show the concept...

' Create variables...
Dim oConn
Dim oRS

' Create connection...
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Master","",""

' Create ADO recordset...
Set oRS = Server.CreateObject("ADODB.Recordset")
oRS.Open "Select * from Client",oConn,3,3

' Add a new record...
oRS.AddNew

' Fields...
oRS("clientname").Value = trim(clientname)
oRS("address").Value = trim(address)

oRS.Update

oRS.Close
Set oRS = Nothing
oConn.Close
Set oConn = Nothing

I also generate primary keys, etc, but do not wish to confuse the code. This is something I have been doing for several years so if you cannot get it to work we can start looking into specific things.

Tom