>Sorry if I'm being dense, but one more time on the Update Conflict issue...
>Say I have a table with the following fields:
>KeyID
>Updated_By
>Last_Update
>FirstName
>LastName
>If User1 changes FirstName and User2 changes LastName, Key and Modified would miss the conflict. (This IS a problem in the VFP version) Key and Timestamp (in SQL Server) would deny the update. Using Key and Updatable can create a string that is too long. Am I clear this time? <g>
>TIA
I don't see that as a conflict because you are updating 2 different fields. The KeyID is only set once and that is at the time the record is inserted into the table. The Updated_By and Last_Update fields always have the user ID of the person who LAST updated the record along with the date/time of the insert or update.
Mark McCasland
Midlothian, TX USA