using OpenDatabase with secured back-ends

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

Guest

I'm trying to use the following code from a Front-end (non replicated)
to synchronize two secured replicated databases

Of course I gain access to the front-end using the appropriate workgroup
file, but in the code when I need to do the sync, I run into problems.

What is the syntax for OpenDatabase so I can run the code below (which works
fine with non-secured databases)?

BTW, there is no password, just a username: "L123456" for example

Public Sub SynchronizeCoda(LocalDBandPath As String, NetworkDBandPath As
String)
On Error GoTo Err_Synch

Dim dbLOC As DAO.Database
Dim dbNet As DAO.Database
'Set dbLOC = OpenDatabase(LocalDBandPath)


Set dbLOC = OpenDatabase(LocalDBandPath)
Set dbNet = OpenDatabase(NetworkDBandPath)

Dim frmwait As New Form_Wait
frmwait.OpenForm "Synchonizing..."
dbLOC.Synchronize NetworkDBandPath, dbRepImpExpChanges

End Sub

Thanks
 
There is no way to specify a different workgroup file with
opendatabase.

Replication is a specialized topic. Maybe try asking in
microsoft.public.access.replication, where the replication folks hang
out.

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
If you are using the same workgroup file to open the FE that the two BE
files were secured with, then OpenDatabase will work fine.

There's likely something wrong with your code to synchronize. Your best bet
is to ask in the replication group. It's a little hard to find using the
interface that you're using but try
http://www.microsoft.com/communitie...5e-4fa9-83fd-74fb8dd5c8ca&lang=en&cr=us--Joan WildMicrosoft Access MVPjonefer wrote:> I'm trying to use the following code from a Front-end (non replicated)> to synchronize two secured replicated databases>> Of course I gain access to the front-end using the appropriate> workgroup file, but in the code when I need to do the sync, I run> into problems.>> What is the syntax for OpenDatabase so I can run the code below> (which works fine with non-secured databases)?>> BTW, there is no password, just a username: "L123456" for example>> Public Sub SynchronizeCoda(LocalDBandPath As String, NetworkDBandPath> As String)> On Error GoTo Err_Synch>> Dim dbLOC As DAO.Database> Dim dbNet As DAO.Database> 'Set dbLOC = OpenDatabase(LocalDBandPath)>>> Set dbLOC = OpenDatabase(LocalDBandPath)> Set dbNet = OpenDatabase(NetworkDBandPath)>> Dim frmwait As New Form_Wait> frmwait.OpenForm "Synchonizing..."> dbLOC.Synchronize NetworkDBandPath, dbRepImpExpChanges>> End Sub>> Thanks
 
Back
Top