Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    1

    Unanswered: ODBC Call Fail/Record locked

    I have recently moved some native Access tables to SQL Server 7. These tables are updated in code. When the update is done via a SQL statement, I get
    "This record is being modified by another user. . . Save, Copy to Clipboard, Drop Changes"

    When the record is being updated via DAO code, I get,
    "ODBC Call Fail"

    Both errors are most irritating and I desperately need to find a way around this. Any suggestions would be greatly appreciated.

    Crystal

  2. #2
    Join Date
    Apr 2004
    Location
    The Netherlands
    Posts
    29

    MS-Access and SQLserver problem solutions

    Hi there,

    Maybe this information helps you on the way...

    -- Microsoft Knowledge Base Article - 128809

    -- Zoek in de Google nieuwsgroepen naar Onderwerp:
    "auto_increment fields and #Deleted in MS Access?"
    Nieuwsgroep:
    -> mailing.database.myodbc

    Greetz,
    DePrins

Posting Permissions

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