ACCESS FEED: [MS_AccessPros] RE: Write Conflict

Jumat, 20 September 2013

[MS_AccessPros] RE: Write Conflict

Mike

Instead of using a main form and a sub form with the same record source, why not put the "header" controls in the form header section? That way you don't need a sub form.

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

--- In ms_access_professionals@yahoogroups.com, <no_reply@yahoogroups.com> wrote:

Duane, the parent form is not editable - it's used as a header for consistent data such as name, address, etc. The subform is the editable form and does not have the same fields as the parent.

Thanks in advance!
Mike

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> Mike,
>
> Can you justify/explain the form and subform being bound to the same table? If you edit the record on the main form and then edit the same record on the subform, I expect you will get the write conflict error.
>
>
> Duane Hookom MVP
> MS Access
>
> ----------------------------------------
> > From: no_reply@yahoogroups.com
> >
> > I have a form and subform bound to the same table. When making a change to a field in the subform and then closing the form, I get the Write Conflict error. However, this does not occur on ALL records. How can I identify the cause?
> >
> > By the way, the table is a linked Oracle table using the Oracle 11g driver. We recently converted from XP to Windows7, and this issue suddenly appeared. Seems to be connected but not totally sure.
> >
> > Thanks in advance!
> > Mike
>