by Was nothing to do with a VPN.
It seems I had a corrupt image field in the Employee table.
I deleted the image out of one of the records (I had worked this out through
a process of elimination) and it starting working again.
I did do a DBCC CheckTable prior but it must not have fixed it.
Anyone had a corrupt image field before?
Adam
--------------------------------------------------------
Check out these HOT UTILITIES FOR ACCESS AND VB DEVELOPERS....
www.ssw.com.au
* SSW Data PRO - Version Control for your data.mdb
* SSW Data Renovator - Compare the differences between two data.mdb's
* SSW Upsize PRO! - Don't UPSIZE to SQL Server without it
--------------------------------------------------------
> > My Merge replication fails over a VPN and I don't know what to try.
> Looking
> > at the Job History in Enterprise Manager I see the following:
> > 1.
> > Uploading data changes to the Publisher
> > Result: In Progress
> > 2.
> > Processing deletions from HIPPO.SSWData
> > Result: In Progress
> > 3.
> > Category:COMMAND
> > Source: Failed Command
> > Number:
> > Message: {call sp_MSdummyupdate (?,?,?,?,0)}
> > Result: In Progress
> > 4.
> > Category:SQLSERVER
> > Source: CHOOK
> > Number: 64
> > Message: Communication link failure
> > Result: In Progress
> > 5.
> > The process could not deliver dummy update at the Subscriber.
> > Result: Retry
> > Then Retries 10 times and fails.... Any things I can try?
> > Adam
> > --------------------------------------------------------
> > Check out these HOT UTILITIES FOR ACCESS AND VB DEVELOPERS....
> > www.ssw.com.au
> > * SSW Data PRO - Version Control for your data.mdb
> > * SSW Data Renovator - Compare the differences between two data.mdb's
> > * SSW Upsize PRO! - Don't UPSIZE to SQL Server without it
> > --------------------------------------------------------