General discussion

  • Creator
    Topic
  • #2077590

    Couldn’t Update-RT Error 3218 Access97

    Locked

    by frankus ·

    I get this Run Time error only when the Access MBD file is on the Network and also on another user’s workstation. It run OK on my NT4 workstation. It happens when running and sending results (40,000 records) to a table.

All Comments

  • Author
    Replies
    • #3737110

      Couldn’t Update-RT Error 3218 Access97

      by dklippert ·

      In reply to Couldn’t Update-RT Error 3218 Access97

      No solution, but here’s the definition of the error:
      Error 3218 ?Could not update; currently locked.?
      This error occurs when a user tries to save a record that is locked by another user. To handle this error, program your solution to wait for a short period of time, and then try to save the record again. Or, you can display a message that explains the problem and give users the opportunity to try the operation again.

      • #3753495

        Couldn’t Update-RT Error 3218 Access97

        by frankus ·

        In reply to Couldn’t Update-RT Error 3218 Access97

        Thanks. Based on this answer, I put error trapping for Error 3218 into the code. It sends control back to the update line, which is eventually successful in completing the task.

    • #3753497

      Couldn’t Update-RT Error 3218 Access97

      by donq ·

      In reply to Couldn’t Update-RT Error 3218 Access97

      Access enjoys both Passive and Sustained record locking. Under your menu options select Tools | Options and select the “Advanced” tab. Make sure Default Open Mode is set to Shared and Defaule Record Locking is set to No Locks.

      The database still locks a single page of records during any update but locking is in the Passive mode and the lock is released as soon as the updated record is saved to disk.

    • #3753494

      Couldn’t Update-RT Error 3218 Access97

      by frankus ·

      In reply to Couldn’t Update-RT Error 3218 Access97

      This question was closed by the author

Viewing 2 reply threads