Terpsichore
Registered User.
- Local time
- Today, 03:56
- Joined
- Jun 5, 2006
- Messages
- 34
Hello all,
I am running an mdb database created using Access 2007. I have been successfully replicating with all my users without issue until recently.
One user had to get a new laptop, and it has Windows 7 - all other computers are still running XP.
My user with Windows 7, when trying to Synch (replicate) gets the run-time error 3251.
I have checked and double checked all the paths and file names and they are all correct.
Here is my code:
Private Sub LDSync_Click()
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim mySyncStart As Date
Dim mySyncPath As String
Set dbs = CurrentDb
mySyncStart = Now()
mySyncPath = "local path on C drive/Replica of DataMASTER.mdb"
Dim DbsTemp As DAO.Database
Set DbsTemp = OpenDatabase("actual network path to master files/DataMASTER.mdb")
DbsTemp.Synchronize mySyncPath, dbRepImpExpChanges
DbsTemp.Close
End Sub
I have checked that the Windows 7 user has full install of Access 2007 and all Reference libraries match my own.
Any ideas whey the Replication is failing?
And just to clariy, she was replicating without issue on her old computer and she can successfully replicate manually by opening the Data files and selecting Synchronize now ... - it just won't synch via the code.
Any help greatly appreciated.
Thank you.
Angel
I am running an mdb database created using Access 2007. I have been successfully replicating with all my users without issue until recently.
One user had to get a new laptop, and it has Windows 7 - all other computers are still running XP.
My user with Windows 7, when trying to Synch (replicate) gets the run-time error 3251.
I have checked and double checked all the paths and file names and they are all correct.
Here is my code:
Private Sub LDSync_Click()
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim mySyncStart As Date
Dim mySyncPath As String
Set dbs = CurrentDb
mySyncStart = Now()
mySyncPath = "local path on C drive/Replica of DataMASTER.mdb"
Dim DbsTemp As DAO.Database
Set DbsTemp = OpenDatabase("actual network path to master files/DataMASTER.mdb")
DbsTemp.Synchronize mySyncPath, dbRepImpExpChanges
DbsTemp.Close
End Sub
I have checked that the Windows 7 user has full install of Access 2007 and all Reference libraries match my own.
Any ideas whey the Replication is failing?
And just to clariy, she was replicating without issue on her old computer and she can successfully replicate manually by opening the Data files and selecting Synchronize now ... - it just won't synch via the code.
Any help greatly appreciated.
Thank you.
Angel