I am getting the message "key column information is insufficient or incorrect. Too many rows were affected by update," when I attempt to update.
I have a project that is linked to SQL Server 2000, in which I have constructed a view of two linked tables. They have the same PK in a one-to-one relationship. Access 2000 is linked to this view.
When I perform an identical update from SQL Server 2000, the change is successful.
I want to use Access 2000 so that I can construct user-friendly forms.