db.Sycnchronize Issues in 2007

[alathwell]

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

 

[David W. Fenton]

Any help with this will be most appreciated.

Apply SR1, which fixed this bug that was part of the original
release of A2K7.