-
I am trying to add data to a database. I am using windows 98 and office 2000.
When trying to add the data i am getting a message
'the operation requested by the application is not provided by the provider'
ADODB.recordset erroe '800a0cb3'
Please can someone tell me what is wrong and how i can sort it out. I have installed the PWS twice thinking it was a faulty instalation. I am able to see the data in the database but not add to it.
-
Show us your code, maybe will see the error!!
-
Without seeing your code, I am going to take a guess that you are either:
1)Not setting the locktype parameter on the recordset.
2)Opening the recordset using a command object's execute method.
3)Opening the recordset using a connection object's execute method.
4)Not setting the cursortype to an updatable cursortype (adOpenKeyset, adOpenDynamic).
But.. please post some code so we can tell ya which one.. :c)
-
Thanks monte96 have sorted it now always nice to know someone can help