I am trying to do the replication between SQL SERVER 7.0 database and MS ACCESS 2000 database. Both the servers have tables and data. Data in most of the tables is different and is required. Both the servers have different front ends for data entry. Most of the tables have same structures except three tables that have more fields than its counter part( SQL server table is subset of MS ACCESS table). There are tables in both the servers which are not common but those are not to be synchronized. Although Most tables have same structures but their names vary. I need to synchronize these once a week. They have different primary keys in respective tables. My question is
1. Which is the best method of doing replication(Merge?..etc.) and steps to do this replication.
2. Is any programming needed, if yes pls help.


Regards
Bharat