[AccessD] Simultaneous edits to ADO

jwcolby jwcolby at colbyconsulting.com
Mon Mar 14 07:48:12 CDT 2011


We have discussed questions regarding what happens when a form is bound to sql server via ado and 
two people edit the same record.  I tested that this morning.

1) The edit symbol is only sporadically supported.  Sometimes the symbol appears, sometimes not.  I 
haven't discovered a pattern yet.

2) if two people try to edit the same record, the first to save does so with no error message, each 
additional save gets the "the record has changed" message and is offered the ability to save to a 
text file or the paste buffer.  The button to overwrite is grayed out.

3) The second person to save gets the message even if they are not editing the same field.  IOW it 
is detected at the record level.

My guess is that this is the same behavior that you would get unbound using ADO.  IOW it is up to 
you to trap the error and do something with it.  since I use a framework I will be adding code to 
trap this error and attempt to discover if the second user is editing a different field.  If so I 
may just save the edit with or without warning.

-- 
John W. Colby
www.ColbyConsulting.com



More information about the AccessD mailing list