Page 3 of 4 FirstFirst 1234 LastLast
Results 31 to 45 of 51
  1. #31
    cdscivic is offline Resident Troll
    Windows XP Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    52
    Hmm, I'll look at that change as well this weekend.



    Currently the username is just a standard module called modUser .

    Yes the macro is just an option on the table in design view. This is the first time I've ever used a macro on the table itself.

    Point of note, moving the lookup field appears to have reduced the frequency of the error but it still occurring daily.

  2. #32
    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
    I did a little research and unless otherwise declared, Functions in Modules are Public by default so your code is fine. The name of your module is different that the procedure it contains so that is also just fine. I will need to study the Data Macro a bit to understand what it is accomplishing and when it executes.

  3. #33
    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
    You should also be able to move that DataMacro to your forms BeforeUpdate Event. Having it in the table can (and probably is) causing a conflict.

  4. #34
    cdscivic is offline Resident Troll
    Windows XP Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    52
    Yea my assumption is that exact train of thought. I'm going to attempt a test move on one form tomorrow to ensure its functionality...then if it successfully updates the table how I need it to, I'll change the rest and move to my production version.

    Thank you so much for the help, I'll post up when done and I have a sample usage worth a darn (generally Tuesday).

  5. #35
    cdscivic is offline Resident Troll
    Windows XP Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    52
    Update made, fingers crossed��☺️
    Last edited by cdscivic; 10-03-2016 at 10:39 AM.

  6. #36
    cdscivic is offline Resident Troll
    Windows XP Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    52
    No problems yet..its not a very heavy volume day on the db though.

  7. #37
    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 for the running update!

  8. #38
    warmslime is offline Advanced Beginner
    Windows 10 Access 2013
    Join Date
    Jan 2016
    Posts
    49
    Just curious, what else is in the BeforeUpdate event of your form? I'm pretty sure data macros are the last thing to run (so after the forms' events, not 100% sure though).

  9. #39
    cdscivic is offline Resident Troll
    Windows XP Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    52
    @RuralGuy no problem, tomm is the heavy use day so we will see!

    @warmslime (lol) nothing was until I moved the "now" formula and the username function into there. I created a regular macro that set the 2 fields and called that macro from the beforeupdate event.

  10. #40
    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
    Go get 'em. I think you've got it!

  11. #41
    cdscivic is offline Resident Troll
    Windows XP Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    52
    Whoop whoop, no issues today. I'm tentatively saying this is solved, bit will wait until Friday to mark the thread solved!

    Seriously, thank you all for the help!

  12. #42
    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
    Excellent! You're certainly most welcome and thanks for the update.

  13. #43
    cdscivic is offline Resident Troll
    Windows XP Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    52
    I hate threads w no resolution, so that in itself dictates I keep it updated through resolution��

    Today, 96 users made 1000+ record updates throughout the 10 hour day. If my calculations are correct, 1.67 updates per minute!

    No reported issues today, although it was a tad slow....still pretty good imo.

  14. #44
    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
    Beautiful! Thanks for the update.

  15. #45
    cdscivic is offline Resident Troll
    Windows XP Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    52
    After struggling with the lack of sample size the last week (thanks TO Hurricane Matthew since I am in Jacksonville, Fl), im going to say this is solved. While removing the lookup field helped minimize the locking issue, the big hit solution seemed to be removing any and all coding and macros from the table. Lesson learned here?

    Tables are for data and nothing else.

    If you are experiencing record locking like this, remove anything from your table that is more than just housing data. It should not be performing any operations and it escapes me why this is even an option in Access.

    Thank you for all the help on this everyone!

Page 3 of 4 FirstFirst 1234 LastLast
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