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 (6) |
Tidak ada komentar:
Posting Komentar