Update different records in a Linked Table

[Lorlai]

I have a table linked from my Access 2007 database to my Sharepoint site. This table is created from new information that is downloaded once a week. The data may or may not change for each record, and there may be records that will need to be newly created. I need to keep each record (as users on the Sharepoint site can update the records), but also want to make sure there will not be duplicate data. For example, one product may have a status of great the first week, and then go to critical the next week, but will still have the other information associated with that product remain the same.

Any one have any advice about this?

Thank you!