I want to compare 2 tables in Access 2000 record by record. Using the primary key, I need to check one field to see if it is different in the 2 tables. If it is, I want to write the whole record to a different table, then go to the next record. I want to do this in Access before I upload the database to the server. Can anyone help? Thanks.