Synchronization problem on different computer

[Neomalfoy]

I have a master access 2007 db that I was given (I did not create the original master db) and I also have a replica of the db that was updated on a different computer. I am trying to synchronize the replica with the master. I though I could get the replica to find the master by using the recover design master option in replication options but it can't find it because it's looking for it in the location it was on the original computer (which doesn't exist anymore).

Is there anyway I can get around this?

 

[Remou]

Did you use recover design master on the replica? If so, it is no longer a replica and cannot be synchronised. You should synchronise from the master, you will be allowed to select the replica that you want to synchronise with, it has been a while, so I cannot remember the exact menu choices. Moving replicas is not a problem, moving design masters can be.

 

[Neomalfoy]

That is probably the root of the problem, the computer the design master was created on doesn't exist anymore, but I do have the design master.

When I try to synchronize from the design master the only option I can click on under replication options is 'create replica' the other ones i.e. 'synchronize now' are greyed out.

 

[Remou]

I fear you will have to use code to compare the tables.