PDA

Click to See Complete Forum and Search --> : adding data to a database


nutstretch
Nov 22nd, 2000, 05:10 AM
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.

sebs
Nov 22nd, 2000, 07:21 AM
Show us your code, maybe will see the error!!

monte96
Nov 22nd, 2000, 08:30 AM
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)

nutstretch
Nov 22nd, 2000, 03:14 PM
Thanks monte96 have sorted it now always nice to know someone can help