Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    New Jersey, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Couldn't update; currently locked. 3218 DAO.Record (97 2)

    I hope someone can help me. I keep getting the error "Couldn't update; currently locked. 3218 DAO.Recordset" when I run this code. I am able to append around 6000 records before it bombs. I am running this on a Novell Server but in a test enviornment so there are no other users in the database but me. My code is really quite simple it just loops through a text doc and appends the records into a table. By the way this code worked perfectly for a few months it just causing problems.

    Thanks for any insight you may be able to give me.

    Cathy

    Long piece of code moved to attachment by HansV

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Couldn't update; currently locked. 3218 DAO.Record (97 2)

    Could it be that there is a set of lines that lacks the line for record number 6? That could lead to problems (another AddNew before Update has been executed)
    Or a set of lines without record number 1? That would cause the code to edit a record without having used AddNew.

  3. #3
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    New Jersey, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Couldn't update; currently locked. 3218 DAO.Record (97 2)

    Hans,
    It must have something to do with running this over the network on a Novell server. I moved everything to my harddrive and it ran with no problems.
    Cathy

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Couldn't update; currently locked. 3218 DAO.Record (97 2)

    The following MSKB article might be relevant, although it's about deleting records instead of adding them: ACC97: Error 3218 "Couldn't Update; Currently Locked" When You Delete Records in a Database on a Novell Server.

  5. #5
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    New Jersey, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Couldn't update; currently locked. 3218 DAO.Record (97 2)

    Hans,
    Thanks I have seen that article and actually set my deletions up using the query method. I think will have to talk to the Novell boys.

    Again 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
  •