Replication Upgrade Issue

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
I want update my post...
I identified the problem. It was a trust issue between networks.

Dwight
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top