I have created a replicated split database. Only the backend is replicated. I have used the code below to manage the synchronization of the backend tables with the DesingMaster backend.
The database is secured by a workgroup and users run the database via a shortcut with a command line pointing to the work group. Which they then have to enter a username and password.
The database is distributed across several on laptops hence the the
replication and each copy has it own copy of the work group file.
When running the database in 2003 the syncchronization process works
perfectly. However when running in 2007 directly - by double clicking the
shortcut on the desktop and logging into the database. Then running the sync process I get and the following error message:-
'Operation is not supported for this type of object'
However if I run another database in desgn mode showing database window etc. so I can close just the datbase and leave access running. Then I open the same database that produced the above error it works ok, no error message.
This is the code I am using:-
Public Function Sync_BackEnd_Tables() 'This function synchronises backend
replicated tables
DoCmd.OpenForm "frmBackenSyncPathControl", , , , , acHidden
Dim replicastrLocal, pathstring As String
Dim db As DAO.Database
pathstring = Forms![frmBackenSyncPathControl]![pathname] 'Variable
assigned filename and path from pathcontrol form
replicastrLocal = Mid(CurrentDb.TableDefs("tblEventTypes").Connect, 11)
Set db = DBEngine.OpenDatabase(replicastrLocal)
db.Synchronize pathstring
db.Close
Set db = Nothing
MsgBox "Synchronisation Complete", vbInformation, "Sync Message"
DoCmd.Close acForm, "frmBackenSyncPathControl"
End Function
Any help with this will be most appreciated.
Regards
alathwell
The database is secured by a workgroup and users run the database via a shortcut with a command line pointing to the work group. Which they then have to enter a username and password.
The database is distributed across several on laptops hence the the
replication and each copy has it own copy of the work group file.
When running the database in 2003 the syncchronization process works
perfectly. However when running in 2007 directly - by double clicking the
shortcut on the desktop and logging into the database. Then running the sync process I get and the following error message:-
'Operation is not supported for this type of object'
However if I run another database in desgn mode showing database window etc. so I can close just the datbase and leave access running. Then I open the same database that produced the above error it works ok, no error message.
This is the code I am using:-
Public Function Sync_BackEnd_Tables() 'This function synchronises backend
replicated tables
DoCmd.OpenForm "frmBackenSyncPathControl", , , , , acHidden
Dim replicastrLocal, pathstring As String
Dim db As DAO.Database
pathstring = Forms![frmBackenSyncPathControl]![pathname] 'Variable
assigned filename and path from pathcontrol form
replicastrLocal = Mid(CurrentDb.TableDefs("tblEventTypes").Connect, 11)
Set db = DBEngine.OpenDatabase(replicastrLocal)
db.Synchronize pathstring
db.Close
Set db = Nothing
MsgBox "Synchronisation Complete", vbInformation, "Sync Message"
DoCmd.Close acForm, "frmBackenSyncPathControl"
End Function
Any help with this will be most appreciated.
Regards
alathwell
