write conflict
From: michael eaton (michael.eaton_at_pago.co.uk)
Date: 04/27/04
- Next message: Kyle Jedrusiak: "Accessx XP / SQL 2000 / "sa" vs "non sa" user"
- Previous message: Lyle Fairfield: "Re: Prblems with EOF Marker"
- Messages sorted by: [ date ] [ thread ]
Date: 27 Apr 2004 04:06:32 -0700
i have an issue using access 2000 ADP project as an interface with SQL
2000. I cannot lock the record when opening a form and if two users
edit the same data i get a write conflict with the message "This
record has been edited by another user since you started editing
it....." with the option to save, discard or copy the changes.
I have trawled MS knowledge base etc with no result.
How can i turn off the message and trap the error. I cannot get the
error to trap, someone told me that it should generate error 3260 but
none of these seem to occur. On form_error i get err.number 0 but
still the write conflict message.
Any suggestions, this is really frustrating.
Thanks
Michael Eaton
- Next message: Kyle Jedrusiak: "Accessx XP / SQL 2000 / "sa" vs "non sa" user"
- Previous message: Lyle Fairfield: "Re: Prblems with EOF Marker"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
