On May 6, 1:47=A0am, "Larry Linson" <boun...@[EMAIL PROTECTED]
> wrote:
> "EManning" <manning_n...@[EMAIL PROTECTED]
> wrote
>
> > Using A2003. =A0I've got an FE with a main form with a subform. =A0The
> > subform is a mixture of bound and unbound fields. =A0The main form is
> > unbound and all it has on it is a combobox to choose a patient's
> > name. =A0Once the patient is chosen, the subform refreshes to show
that
> > patient's data. =A0The problem I'm having is that 2 or more users
could
> > select the same patient and attempt to update the subform.
>
> In multiuser environments, each user should have his/her own copy of the
> Front End, linked to shared tables with data, in the Back End. =A0That
wil=
l
> alleviate your problem... provided you use proper locking, which is
> certainly possible...
>
> =A0Larry Linson
> =A0Microsoft Office Access
>
> If user #2
>
>
>
> > tries to update a bound field (haven't tried unbound yet) on the
> > subform, they get a "beep" and the "no edit" icon appears in the
> > record selector on the left-side. =A0I'm trying to trap that to
display
> > a message to them that the patient is being edited by someone else.
> > But I cannot seem to figure out where the error is occurring. =A0I've
> > set breakpoints in the Form_Error event, but it won't trap the error.
> > I've set breakpoints in events for various bound fields on the subform
> > but I still cannot trap the error. =A0I would like for other users to
be=
> > able to view the patient's data while another user is editing, just
> > not be able to edit it.
>
> > The BE mdb is set to Shared, and "Edited Record".
>
> > Thanks for any help or advice.- Hide quoted text -
>
> - Show quoted text -
Each user does have their own FE. The BE is set to Shared and "Edited
Record". Should it be set to something else?
|
