Updating a recordset

Results 1 to 2 of 2

Thread: Updating a recordset

  1. #1
    Join Date
    Dec 1969

    Default Updating a recordset

    I would like to add a record to a recordset. I&#039m not interested in writing the new entry back to the database, just want to add a blank record (long story). When I use oRS.AddNew I receive the following error: <BR>The operation requested by the application is not supported by the provider.<BR>Is the provider the Microsoft Jet DB Engine? My provider version in the ADO connection object properties collection is 02.10.3711.0.<BR>Do I need a newer version? I&#039m running IIS 3. What&#039s my problem here?<BR>Thank you,<BR>Mike

  2. #2
    Join Date
    Dec 1969

    Default RE: Updating a recordset

    How are you opening your recordset? If it&#039s something like<BR>Set rs = conn.execute somesql, it&#039s not updateable. You need to do something like<BR><BR>rs.open somesql, conn, 3, 3, 1<BR><BR>That will give you an updateable recordset

Posting Permissions

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