I have issue updating date field on table. Here is the situation.

I create a new record onto table:
dim fieldsArray(1)
dim valuesArray(1)
fieldsarray(0) = "sdate"
valuesarray(0) = date
fieldsarray(1) = "stime"
valuesarray(1) = FormatDateTime(now(),vbshorttime)

Recordset1.addImmediate fieldsarray, valuesarray

Then on 1 other page I go back to this record to update 2 other Date and Time fields:
Recordset1.fields.setValue "edate",date
Recordset1.fields.setValue "etime",FormatDateTime(now(),vbshorttime)


it is then that I get the error:

Microsoft Cursor Engine error '80040e38'
Row cannot be located for updating. Some values may have been changed since it was last read.

If I change the fields type to tinytext it is working otherwise nothing.

I'm fighting with this for the last 2 days...