PROBLEM:<BR>Have a local Access database and a remote SQL Server. Need to push all updated data from the local DB and to retrieve all new records from the remote DB.<BR><BR>QUESTION:<BR>I have been researching this for the better part of this morning. However, I haven&#039;t found an answer that seens appropriate yet.<BR><BR>Logically, I could just do an insert for all of the unique ID&#039;s above the current MAX(ID) in the local DB and then just update all records in the remote DB, but performance-wsie, this seems rather cumbersome and redundant.<BR><BR>Is there a better way?<BR><BR>Any help is MUCH appreciated.