Page 4 of 4 FirstFirst 1234
Results 46 to 51 of 51
  1. #46
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Thanks again for the update.

  2. #47
    cdscivic is offline Resident Troll
    Windows XP Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    52
    Random update, not one locking issue so far since these last updates. Consistently 50-100 people on it processing 1000+ records daily in 10 hours m-f.

  3. #48
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Thanks again!

  4. #49
    Kev86 is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Dec 2022
    Posts
    36
    RuralGuy or cdscivic I am really hoping either of you can help me with this issue. I have the exact same issue as cdscivic where I have an access database which is used by about 50 people simultaneously and usually at least 4 times per week at some point everyone will get the "Could not update; currently locked" error. Reading through this post it appears that cdscivic had the same issue and it related to macro's built into the table. I have the same where I have a AfterUpdate macro in a table that posts a user name and timestamp in a separate table when a field is updated. It sounds like that's causing the issue and the resolution is to move the DataMacro to a forms BeforeUpdate event. However I have looked into this and can't work out how to move that macro to the form rather than it being situated in the table. Any help would be much appreciated.

  5. #50
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    This thread is over 6 years old and neither respondent has posted for two years or more.

    What you are doing is called 'hijacking a thread'. Recommend you start your own thread setting out your situation. By all means refer to this thread, but you are more likely to get responses with a new thread since this one is marked 'solved'

  6. #51
    Kev86 is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Dec 2022
    Posts
    36
    Ok thank you CJ for your response, not used this site before and not used to writing on forums. I will create a new thread.

Page 4 of 4 FirstFirst 1234
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 10-08-2015, 01:13 PM
  2. Can't update record, currently locked
    By clancy76 in forum Access
    Replies: 5
    Last Post: 04-16-2015, 10:20 AM
  3. BeforeUpdate: Could not update; currently locked.
    By v7davisa in forum Programming
    Replies: 3
    Last Post: 09-26-2014, 04:18 PM
  4. Could Not Update, Currently Locked
    By jlclark4 in forum Forms
    Replies: 5
    Last Post: 11-17-2011, 01:21 PM
  5. Err# 3218: Could not update; currently locked.
    By reachvali in forum Access
    Replies: 3
    Last Post: 06-30-2011, 05:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums