VBScript ADO error driving me crazy

[labboy999]

Here is my code:

set cnConnection = CreateObject("ADODB.Connection&quot
cnConnection.Mode = 3
cnConnection.open "project"

set rsCust = CreateObject("ADODB.Recordset&quot
rsCust.ActiveConnection = cnConnection
rsCust.CursorType = adOpenKeyset
rsCust.Source = "customer"
rsCust.open
rsCust.AddNew

I created an ODBC profile for the connection project when I try to execute this, i get this error: ADODB.REcordset: Unknown runtime error. It happens at the .addnew part, any suggestions?

 

[Mighty]

Try adding a lock type for the recordset - for example, adLockOptimistic Mise Le Meas,

Mighty