Re: View Synchronization History

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jack MacDonald (jackMACmacdonald_at_telus.net)
Date: 12/22/04 

Date: Wed, 22 Dec 2004 03:24:18 GMT

I don't have a "real" replica set on this computer. However, I just
created a one-table MDB, replicated it, and synchronized. The table
named MSysExchangeLog seems to hold the info that you want -- it
contains a new record each time that it is synchronized. Look in the
field named LastCommunication for a timestamp.

On Tue, 21 Dec 2004 17:20:12 -0800, "Mike"
<anonymous@discussions.microsoft.com> wrote:

>Jack,
>Thanks. That was actually the first think I looked for.
>I really couldn't find a table to made any sense.
>
>>-----Original Message-----
>>Yes - one of the hidden MSys... tables stores that
>information. Can't
>>recall it's name at the moment, but just open your
>backend file, go
>>into options and turn on the Hidden and System objects,
>and you will
>>be able to figure out which table holds the info.
>>
>>Of course, you will need to LINK from your frontend to
>the backend for
>>the enduser to see the appropriate table. IIRC, this
>information is
>>kept local to the specific replica.
>>
>>
>>
>>On Tue, 21 Dec 2004 06:48:05 -0800, "Mike"
>><anonymous@discussions.microsoft.com> wrote:
>>
>>>I'm using Jet 3.5.1 SP3 with Access 97. Is there a way
>to
>>>create a form that displays the information that you
>would
>>>get if you right-clicked on your server synchronizer in
>>>Replication Manager and selected "View Synchronization
>>>History"?
>>>
>>>I have a number of remote users who have Replication
>>>Manager on their system. If there is a concern about
>them
>>>syncing I have them load the RM and check the log. I'd
>>>like to be able to have a button off the Main Menu of my
>>>program that they could click and see similar info that
>RM
>>>shows without then having to load RM.
>>>
>>>Any thoughts?
>>>Thanks
>>>Mike
>>
>>
>>**********************
>>jackmacMACdonald@telusTELUS.net
>>remove uppercase letters for true email
>>http://www.geocities.com/jacksonmacd/ for info on MS
>Access security
>>.
>>

**********************
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

Quantcast