Ms Access 2000 and Linked Tables to SQL 2005 - Update Record Problem

[Simon_Whale]

Having a strange problem on a legacy system. In one of the records if the user tries to update it they get the following error "This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes. Options are Save Record (greyed out), Copy to Clipboard, and Drop Changes." We've tried the follow 1. updating the record manual in SQL Server Management Studio - This works 2. Updating the record in Access, through the link table and we get the above error if we drop the linked table and rebuild we get same error if we update the table in Access or on the form. any other suggestions? Simon

As barmey as a sack of badgers