I am trying to find a solution to the following problem. The error is 'Data Provider or other service returned an E-FAIL error. Number- 2147467259'. This happens when I add a new record to this table. Everything works fine when I have a small set of records. Currently I have about 24,000 records and the table size is 20M. I am using VFP 6.0 as the back end database and VB 6.0 (SP 5.0). I am using the following code:

Set rsInsert = New ADODB.Recordset
With rsInsert
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
.Open "quotes", gDBConnection, , , adCmdTable
.AddNew 'This is where it throws me out

!QuoteDate = QuoteDate
!PropertyId = PropertyId
!CustomerId = InsuredData.nCustomerId


Thanks in advance.