Access is getting lock errors

Results 1 to 2 of 2

Thread: Access is getting lock errors

  1. #1
    LeeAnnie Guest

    Default Access is getting lock errors

    I have a website that is getting more hits than I bargained for. I know, I know.... so what is the problem with that, you ask?<BR><BR>Well, when users submit a form, they are receiving a "Update locked" error generated by Access. The problem is due to the simultaneous attempts to update the tables in the database at the same time.<BR><BR>I will soon be migrating this website to SQL Server, but until my customer can procure a hefty purchase order, I must "make do" with what I have.<BR><BR>Has anybody else had this problem? What did you do to "bandaid" this problem? Did you capture the error and loop until the tables were unlocked?<BR><BR>Thanks in advance for any help and/or advice!

  2. #2
    Reggie Guest

    Default RE: Access is getting lock errors

    Just be absolutely sure you closed all your connections and recordsets and then set them equal to nothing. And of course have a message to let users know about the problem so they don&#039;t think it&#039;s an error and just give up if it doesn&#039;t work once or twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts