Recordset.AddNew

Hi everybody,;

I seem to get this error when I use Recordset.AddNew:

Operation requested by application is not supported by the provider.

The same happens when I use RecordSet.Delete

Please help me.

:) ;)

What type of provider you r using?
What type of cursor, lock u r using while opening the recordset ?

Regards

Gary

Thank you Champgary for the reply

I am using SQLOLEDB as my provider

Cursor Type : adOpenDynamic

Lock Type: adLockOptimistic


:) :)

post your code