>I created a program to update tables in a database but in one table when I edit the field more than once in the same session a message box comes up saying this field has been edited by another user already, continue with edits? Yes or No. When I press Yes (when the views are configured for Key and Updatable) it changes all the fields to the last changed field. I created this program using Wizards and it seems like it is only one table that has this problem. I am using SQL 7 and also using views.
>
>Thanx
Are you using remote views on SQL Server data? Are you doing a table update to the server to update the first edit? Or are you just sending all the records that were editied back to the server in one pile?