Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    8

    Question Unanswered: How to prevent record locking

    It may be a stupid question but I'll ask you for help:

    I have a DB, split in front and back end - back end on server, front end on users PCs.
    When there are two or three users the application works fine.
    When there are more users some of them are receiving "Couldn't update. Record may be locked" message.
    THE FORMS THAT FILL THAT DB ARE BASED ON TABLES! I'm a begginer but I suppose that is the problem. If that's the case - WHAT SHOULD I DO TO PREVENT RECORD LOCKING??? I remember reading somwhere that I should base my forms on queries instead on tables but CAN SOMEONE TELL ME HOW THIS SHOULD BE DONE.

    And could there be another problem??? Because most of the time, when 2 or 3 PC are working simultaniously with a same form there is no problem (I'm thinking that if one PC opens a form and locks the tables it shold block the work on all the other PCs. But most of the time 2 - 3 PCs are working fine simultaniously?!?!?!).

    I'LL BE EXTREMELY GRAITFULL IF SOMEONE CAN HELP ME!
    THANKS

  2. #2
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    As posted by CyberLynx in the Thread entitled "Forms"

    The record you modify should change and remain changed. Check the following options:

    1) Go to the Tools menu and select Options;
    2) Select the Advanced tab;
    3) Make sure the following are selected:

    --- Default Open Mode {Shared}
    --- Default Record Locking {No Locks}

    Close and Restart your database. Now try it.


    Im not 100% sure if this'll solve your problem, but it would be a good place to start from.

  3. #3
    Join Date
    Oct 2003
    Posts
    8
    Thank you for the reply cruickshanks but both options are selected... (

  4. #4
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    How have you got the data to the front end? are you using linked tables, ODBC or DAO/ADO links?

  5. #5
    Join Date
    Oct 2003
    Posts
    8
    All the data is in the back-end.
    I'm using linked tables in the front end

Posting Permissions

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