Write conflict

[xanders]

When two users change the same record there wil be a
message fired of by MS Access (2000) "Write conflict".
This message has no err.number and I can't trigger this
message. Can somebody help me to trigger this message so I
can explain the user what kind a problem just happened and
what to do.

 

[Arvin Meyer]

I believe the error number you are looking for is: 3188
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Hi Arvin

There is no errornumber fired off.
I trigger some essential events (Form_Current,
Form_AfterUpdate, Form_Error) but none of these events
will trigger this message. I believe it is an ODBC error
and that is difficult to trigger I heard.
Maybe you know now what I mean.

 

[Arvin Meyer]

There was no mention of a server database in your first post. Access/JET
does not use ODBC, but server databases can use either ODBC or OLEDB to
connect to the front-end (Access) Unfortunately, ODBC does not always convey
errors properly back to the front-end, so you may not get a helpful message.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access