synchronizing databases through VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi - I have 2 secured replicas that I want to synchronize with code, but get
"Dont have permissions" error message when I assign the RepDesignMaster =
DestinationRep in the following code:
Dim RepDesignMaster As New JRO.Replica

RepDesignMaster.ActiveConnection = DestinationRep

I have admin rights to the databases in question and can synchronize them
through the Tools menu with no problems. How do I open the RepDesignMaster
with a specific userid and password? In the field the users will not have
admin rights to the databases, but will have full data rights, so would I
need to use a user id and password to achieve the synchronization, but
where/how do I do this? Thanks - Jenny
 
Jenny:

It would be helpful to see the value of the DestinationRep variable you are
assigning to the ActiveConnection property. Can you provide more
information?

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi - I have 2 secured replicas that I want to synchronize with code, but get
"Dont have permissions" error message when I assign the RepDesignMaster =
DestinationRep in the following code:
Dim RepDesignMaster As New JRO.Replica

RepDesignMaster.ActiveConnection = DestinationRep

I have admin rights to the databases in question and can synchronize them
through the Tools menu with no problems. How do I open the RepDesignMaster
with a specific userid and password? In the field the users will not have
admin rights to the databases, but will have full data rights, so would I
need to use a user id and password to achieve the synchronization, but
where/how do I do this? Thanks - Jenny
 
Back
Top