I'm trying to update a table using Access 97 and VB5 with an identical table in another database that contains changes- changes within the records, addtions & deletions of records. The old table can't be replaced because of existing relationships and database replication is really not an option. If anyone has any ideas please respond. Thanks.