G
Guest
Our office recently upgraded to MS Access 2003.
In my main menu I have a commend button to force syncronization. The code
behind the button is:
*********************************************
Dim rep As New JRO.Replica
strPrograms = Command()
DoCmd.Hourglass True
DoCmd.OpenForm "Synchronization in Progress"
Select Case Left(strPrograms, 1)
Case "I"
rep.ActiveConnection = "[path]"
rep.Synchronize "[path]", jrSyncTypeImpExp, jrSyncModeDirect
Set rep = Nothing
Case "i"
rep.ActiveConnection = "[path]"
rep.Synchronize "[path]", jrSyncTypeImpExp, jrSyncModeDirect
Set rep = Nothing
....
End Select
....
****************************************************
When I try to run the sycronization I get the following error:
The Microsoft Jet Database engine cannot open the file. It is already
opened exlusively by another user, or you need permissions to view its data.
I can open the data file without any problems.
Does anyone have any ideas how to fix this problem?
Thanks in advance!
Dwight
In my main menu I have a commend button to force syncronization. The code
behind the button is:
*********************************************
Dim rep As New JRO.Replica
strPrograms = Command()
DoCmd.Hourglass True
DoCmd.OpenForm "Synchronization in Progress"
Select Case Left(strPrograms, 1)
Case "I"
rep.ActiveConnection = "[path]"
rep.Synchronize "[path]", jrSyncTypeImpExp, jrSyncModeDirect
Set rep = Nothing
Case "i"
rep.ActiveConnection = "[path]"
rep.Synchronize "[path]", jrSyncTypeImpExp, jrSyncModeDirect
Set rep = Nothing
....
End Select
....
****************************************************
When I try to run the sycronization I get the following error:
The Microsoft Jet Database engine cannot open the file. It is already
opened exlusively by another user, or you need permissions to view its data.
I can open the data file without any problems.
Does anyone have any ideas how to fix this problem?
Thanks in advance!
Dwight