Help..can't insert a record into an access table

[nathb]

I am trying to insert a record into an access table from vb5.0 using ADO. the following is the code and somehow it doesn't throw any errors and the insert doesn't happen.can some one tell me if I am doing something wrong here.


Dim rst_tblSwapvolatilites As ADODB.Recordset
Dim iindex_tablefields As Integer

Set rsSwap_Historydate = lclsDataRet.GetResult(gsConnection, ssql, 0)
If rsSwap_Historydate.RecordCount = 0 Then
rsSwap_Historydate.AddNew
rsSwap_Historydate(iindex_tablefields).Value = CDate(sSwap_HistoricalDate)
For iindex_tablefields = 1 To 70
rsSwap_Historydate(iindex_tablefields).Value = dblArray_DataPoint(iindex_tablefields - 1)
Next iindex_tablefields
rsSwap_Historydate.Update

thank you
nath