addnew and update methods don't work

Results 1 to 3 of 3

Thread: addnew and update methods don't work

  1. #1
    Join Date
    Dec 1969
    Posts
    540

    Default addnew and update methods don't work

    I have written some very simple scripts that should be able to either add a record or update an existing record in an Access database.<BR><BR>I&#039ve been able to track the extent of execution of the code in both cases with print statements.<BR><BR>In both cases, the code will not execute past the "addnew or update" methods of the Recordset object.<BR><BR>Is there something in IIS 4 or NT that may be blocking these methods?

  2. #2
    malc@couriertracker.com Guest

    Default RE: addnew and update methods don't work

    Have you included "adovbs.inc" and are you setting the switches on the recordset object.<BR>e.g.recordset.open([source].[ActiveConnection],[CursorType],[Locktype],[Options])<BR><BR>You can always try <BR>if Recordset.Supports(adAddNew) then<BR> &#039code for adding record<BR>else<BR> Response.write "Can&#039t add records"<BR>end if<BR><BR>

  3. #3
    Jairo Guest

    Default RE: addnew and update methods don't work

    Bill,<BR>What cursor type options are you opening the recordset with?<BR>Static and forward-only recordsets aren&#039t updatable.<BR><BR>Use a dynamic cursor type of adOpenDynamic or adOpenKeyset instead.<BR><BR>HTH,<BR>Jairo<BR>http://www.citywebarchitects.com

Posting Permissions

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