>> They have different primary keys in respective tables.

Would you expand on this point a little more?

SQL Server is capable of replicating with a data stores other then SQL Server using Push subscriptions. The BOL covers this topic pretty well. Check out the topic Replication and Heterogeneous Data Sources in the BOL.

One point to remember: replicating with Access will require that the account that the mssqlserver service is using has access to the location where the Access database is stored.

-Mike