A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

trying to minimize Write Conflicts in a multi-user database



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old January 14th, 2010, 06:57 PM posted to microsoft.public.access,microsoft.public.access.formscoding,microsoft.public.access.multiuser,microsoft.public.access.queries
Paul
external usenet poster
 
Posts: 126
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.