See a list of replicas from the master 1

[sqleptical]

In Access 2000, is there a way to get a list of the Replicas that have been created from the Master?

 

[Remou]

As far as I recall, you can see a list when you choose Tools->Replication->Synchronize Now. I also think there is a system table that lists them, but my memory is hazy on that point.

http://lessthandot.com

 

[sqleptical]

Thanks for your response.

I understand that Tools->Replication->Synchronize Now will show a list of databases synchronized from the Master, but I'm looking for a list of Replicas made from the master (using Tools->Replication->Create Replica).

...a system table that lists them, like you said for synchronized tables, but instead, for Replicas created from the Master.

I'm doubtful this exists, but I wanted to be sure.

Thanks again.

 

[Remou]

As far as I recall, the list of database that can be synchronized is the list of databases that have been created, as long as replicas have not been removed from the list.

http://lessthandot.com

 

[MajP]

look at mSysReplicas table to see if that meets your needs.

 

[sqleptical]

Awesome, MajP! Thanks!!