Thanks...

At this point the updates will be infrequent, but thanks, I will keep that in mind if it scales out.

Might there be a better way to do it than this?...

Thanks guys, I found another way around it.

I wanted the replication job to run everytime there was an update or insert on a table in the parent sql server,...

Thanks...

I have only set the ADO connection to use the sa account for testing... trying to get this working as I wasn't sure if this was a permissions issue or...