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.


Thank you,
Daniel


Daniel Hutchins
Woodbridge, CA
http://www.finehomemadesoap.com

__________________
Daniel Hutchins
Stockton, CA
http://www.finehomemadesoap.com

I have noticed that when you use ADO in VBA, this message appears when you either update the Key field, or you don't have a key field and you update the field that VBA has decided to use to uniquely identify your records. When I added a key field to my MS Access table, my code ran several times with an error.



Allan