Showing posts with label notebooks. Show all posts
Showing posts with label notebooks. Show all posts

Sunday, March 11, 2012

Can subscriber know the results of Merge rep?

We have two notebooks doing Merge replication (PULL) from the distributor.
We use the Active-X merge from ACCESS.
Can the subscriber know the results of the replication? I now go to EM on
the publisher and look at the Merge Agents to see if there were conflicts,
then to the conflict viewer. Is there a way I can know from the subscriber
doing the Pull?
Thanks,
Steve
Use the status event.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SteveInBeloit" <SteveInBeloit@.discussions.microsoft.com> wrote in message
news:7A88B570-396C-4FB6-BE96-12F60CD99AE6@.microsoft.com...
> We have two notebooks doing Merge replication (PULL) from the distributor.
> We use the Active-X merge from ACCESS.
> Can the subscriber know the results of the replication? I now go to EM on
> the publisher and look at the Merge Agents to see if there were conflicts,
> then to the conflict viewer. Is there a way I can know from the
> subscriber
> doing the Pull?
> Thanks,
> Steve
|||Hi,
I am having trouble making it work in VBA behind ACCESS. In VB, looks like
you would use:
Private WithEvents mobjMerge As SQLMERGXLib.SQLMerge
in VBA, it would bd
DIM mobjMerge As SQLMERGXLib.SQLMerge.
I cannot get the WithEvents in anywhere where it will pass the compiler.
any thoughts.
"Hilary Cotter" wrote:

> Use the status event.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "SteveInBeloit" <SteveInBeloit@.discussions.microsoft.com> wrote in message
> news:7A88B570-396C-4FB6-BE96-12F60CD99AE6@.microsoft.com...
>
>