Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Washington DC
    Posts
    5

    Unanswered: ADO update method Access vs MS SQL

    I have taken over a project where someone was updating an Access database using the ado .update method.

    I have changed the database from access to SQL all seems to be fine until a record is updated and multiple records are being update.

    I'm really just wondering is there is anything obvious that anyone has come across as to why this may be happening.

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    108
    Try opening the recordset with: adOpenKeyset, adLockOptimistic

Posting Permissions

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