Microsoft help emailed me with the following message. I am trying to create a button that will replicate without closing the db first. and another button to sync without closing. Because supposidly you cannot replicate when the db closes in the runtime version of access. So she sent me this code to put in the click procedure. But i am not sure how to do this. i tried and all i get is errors. Can anyone give me more step by step instructions. I really appreciate it. Dan...
Hi Dan,
Synchronizing cannot be done from within a runtime application because the database must close and reopen to complete the process. The runtime application cannot close and reopen itself.
To create a replica, the database must synchronize when creating the replica and for the same reason above, this cannot be done.
We can use JRO code (Jet Replication Objects) to get around this because the database does not have to be closed.
What you will have to do is create a command button on a form for each task - A button to synchronize, and a button to Create a replica.
Add a reference to JRO under Tools References in the VBE. (Visual Basic Editor)
Create a form with two buttons.
Behind the button to Synchronize, copy this code.
Dim repMaster As New JRO.Replica
repMaster.ActiveConnection = currentproject.connection
‘ Synchronize the values.
repMaster.Synchronize “C:\Path to replica”, jrSyncTypeImpExp, jrSyncModeDirect
this code should appear above End Sub
Behind the button to Create a Replica, copy this code
Dim x As New JRO.Replica
Dim y As String
y = InputBox(“Enter path for replica”)
x.ActiveConnection = CurrentProject.Connection
x.CreateReplica y, “My Full Replica1”, jrRepTypeFull, jrRepVisibilityGlobal
this code should appear above End Sub
Hi Dan,
Synchronizing cannot be done from within a runtime application because the database must close and reopen to complete the process. The runtime application cannot close and reopen itself.
To create a replica, the database must synchronize when creating the replica and for the same reason above, this cannot be done.
We can use JRO code (Jet Replication Objects) to get around this because the database does not have to be closed.
What you will have to do is create a command button on a form for each task - A button to synchronize, and a button to Create a replica.
Add a reference to JRO under Tools References in the VBE. (Visual Basic Editor)
Create a form with two buttons.
Behind the button to Synchronize, copy this code.
Dim repMaster As New JRO.Replica
repMaster.ActiveConnection = currentproject.connection
‘ Synchronize the values.
repMaster.Synchronize “C:\Path to replica”, jrSyncTypeImpExp, jrSyncModeDirect
this code should appear above End Sub
Behind the button to Create a Replica, copy this code
Dim x As New JRO.Replica
Dim y As String
y = InputBox(“Enter path for replica”)
x.ActiveConnection = CurrentProject.Connection
x.CreateReplica y, “My Full Replica1”, jrRepTypeFull, jrRepVisibilityGlobal
this code should appear above End Sub
