Hope this is question is OK as it's vb
.net and database related (although not in the book).
I wish to use replication in my app and so have gone into Access and created a Design Master and a Replica database. Now I want to programmatically synchronize the 2 tables (design master is copied to a local folder then synchronized with replica). Here's my code:
Private Function SynchronizeDBs(ByVal strReplicaName As String, ByVal strSynchWith As String, _
ByVal intSynchType As Integer, ByVal intSynchMode As Integer) As Boolean
Dim bSuccess As Boolean = True
Dim rep As New JRO.Replica
rep.ActiveConnection = strReplicaName
rep.Synchronize(strSynchWith, intSynchType, intSynchMode)
Catch ex As Exception
MessageBox.Show(ex.Message & vbCr & vbLf & "Please Report This Message", "Synchronize Error")
bSuccess = False
rep = Nothing
and the calling function:
If SynchronizeDBsJRO(UPDATE_PATH, PROG_PATH, 2, 2) = True Then
' more code
UPDATE_PATH and PROG_PATH are strings defining the design master and replica databases respectively.
Every time I run the programme I receive the following error message:
"Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."
On debugging, the Try Catch traps the error on the assignment of the
rep.ActiveConnection = strReplicaName line.
Can anyone tell me what I'm doing wrong please?