Results 1 to 4 of 4

Thread: adding data to a database

  1. #1

    Thread Starter
    Lively Member nutstretch's Avatar
    Join Date
    May 2000
    Location
    UK
    Posts
    85
    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.

    if at first you don't succeed, drink the rest of the bottle and loop to the same place tomorrow

  2. #2
    Frenzied Member sebs's Avatar
    Join Date
    Sep 2000
    Location
    Aylmer,Qc
    Posts
    1,606
    Show us your code, maybe will see the error!!

  3. #3
    Frenzied Member monte96's Avatar
    Join Date
    Sep 2000
    Location
    Somewhere in AZ
    Posts
    1,379
    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)

    oOOo--oOOo
    __/\/\onte96
    oOOo--oOOo
    Senior Programmer/Analyst
    MCP
    [email protected]
    [email protected]


    Your results may vary.. some restrictions may apply.. pricing and participation may vary.. not available in all states.. professional driver closed course..quantities limited..

  4. #4

    Thread Starter
    Lively Member nutstretch's Avatar
    Join Date
    May 2000
    Location
    UK
    Posts
    85
    Thanks monte96 have sorted it now always nice to know someone can help
    if at first you don't succeed, drink the rest of the bottle and loop to the same place tomorrow

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width