Bill
Great solution!
You are correct the err=7787.
If the form's Record Locks property is set to 'Eited Record'then the other user can't edit her record, this may be a good solution only if is a way to limit the time the first user (the one who locked the record) in edit mode.
Also seems like I am getting an intermittent message that the record is copied to the clipboard.
I am going to keep testing and give you some more feedback.
Thanks
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" wrote:
>
> Dr Norbert
>
> Do you get an error number on that message? If so you can use the Form_Error event to trap it.
>
> I think something like this will work:
> Private Sub Form_Error(DataErr As Integer, Response As Integer)
> If DataErr = 7787 Then
> MsgBox "This record was edited by someone while you " _
> & "were making edits." & _
> "Your edits cannot be saved. Please try again."
> Response = acDataErrContinue
> Me.Undo
> End If
> End Sub
>
> And do you have the form's Record Locks property set to Edited Record?
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, drnorbert@ wrote:
> >
> >
> > Bill the db is split Backend is in SQL 2008- I recall n article from Stan Getz however I can't find it now-the idea is to disable the Standard write conflict message which comes up when 2 or more users are editing the same record at the same time and replace it with a simpler message by trapping the lock type err msg.
> > --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" wrote:w
> > >
> > > I don't think that is possible. And by the way, you won't get that message if you split the database putting all the tables in one back end file in a shared folder and give each user his own copy of the front end file containing all the forms, reports, queries, etc.
> > >
> > > That is the proper way to set up a multi-user database in Access.
> > >
> > > 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, drnorbert@ wrote:
> > > >
> > > > I would like to create a custom message to replace and disable the msaccess 2010 multiuser message.
> > > >
> > >
> >
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (8) |
Tidak ada komentar:
Posting Komentar