If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
trying to minimize Write Conflicts in a multi-user database
I have a multi-user Access 2003 database and lately a number of our users
are running into the Write Conflict message gives them the choice to either Save Record, Copy to Clipboard or Drop Changes. The problem occurs in a tabbed form with subforms on the different pages. I have been told by several developers that one way to minimize the occurrence of the Write Conflict is to put the main form's controls into a subform and remove the Record Source from the main form. You then set Child and Master Field links in the subforms to the value returned by the record selection combo box on the main form (stored in a text box on the main form). In effect, you'd only have one record open at a time from the parent table instead of loading multiple records into the the main form at once. Would this in fact help reduce the number of Write Conflicts? I ask because there are a number of events in the main form the various subforms what would have to be modified, and I'd like to confirm that it will accomplish something before I spend the time making those changes. Thanks in advance, Paul |
Thread Tools | |
Display Modes | |
|
|