Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Do you have any code that will retry when there is a lock?

  2. #17
    Bigdoggit is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    27

    No code to retry

    No, the user can press ESC and get rid of the pencil icon so they can scroll records again. They can then come back and try in a few minutes. Often times the lock sticks around for at least 4 of 5 minutes, sometimes longer and we have to get as many people out as possible hoping whoever is holding the lock exits and releases it. Usually that works too.

  3. #18
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    What did you mean when you said the network drops connections on occasion? Are you using wireless?

  4. #19
    Bigdoggit is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    27

    No wireless....

    There is no wireless, but sometimes people will be working and the form will error out, all bound fields will show # and some error, can't remember now if it says deleted or error, but once they close the front end and open it everything is fine. The networking staff knows there are occasional drops because they have had to deal with that before, so I am putting those two issues together and drawing my conclusion.

  5. #20
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    It would be nice to have some magical answer to this situation but the more you describe the system the more sceptical I become about success. I am afraid I am out of ideas at this point. I'll keep watching this thread and post back if I think of something but the well is dry I am afraid, sorry.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 01-14-2011, 10:37 AM
  2. Entering Text in Combo Form
    By Bobt in forum Forms
    Replies: 2
    Last Post: 10-22-2010, 03:53 AM
  3. Replies: 0
    Last Post: 06-14-2010, 09:41 AM
  4. Open Form in Add Mode
    By Boreal2009 in forum Programming
    Replies: 2
    Last Post: 10-23-2009, 10:53 AM
  5. Control Value Select Append
    By NinjasVsPirates in forum Programming
    Replies: 0
    Last Post: 08-18-2009, 10:42 AM

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