Updating Field Values

Results 1 to 3 of 3

Thread: Updating Field Values

  1. #1
    Richard Moss Guest

    Default Updating Field Values

    How can I update the field values in a RecordSet object? Each time I try, an error occurs stating that the provider does not support this operating.<BR><BR>I am using ADO 2.1 on an Access 97 database.<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Updating Field Values

    If you&#039re using the default firehose cursor (adForwardOnly, adLockReadOnly) you can&#039t do updates because you&#039ve got a read-only cursor. You need to use a different cursor/lock combination - adOpenStatic, adLockBatchOptimistic should do the job.<BR><BR>HTH<BR><BR>Dunc

  3. #3
    Richard Moss Guest

    Default RE: Updating Field Values

    Duncan,<BR><BR>Thanks a lot!!! It work&#039s now. When I program in VB, I still use DAO, this ASP work is my first experiance with ADO, and I obviously have a lot to learn.<BR><BR>Thanks for your help!

Posting Permissions

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