I am using Access97 Front end on SQL 6.5 backend. I have 3 primary keys set on a table, one is an identity column. I am opening up the linked table in access and trying to copy and paste multiple records by using the record selectors. After Updating I get a #DELETED in every field. But after I reopen the table the records that I have just pasted reappear. Shouldn't the identity column update as the records are pasted? If I do the same thing with an access table there is absolutely no problem, everything updates automatically. Help!!