Synchronize splitted database

[IpeXeuS]

Hello mates,

I was wondering (once again ) is there a way to synchronize splitted and replicated database programmatically from users front end when they close database? I've "Data" & "Interface" databases both in users pc and in server as well.

If this sounds a bit odd, please correct me? Is there a point add back end database to users pc as well or only front end database, which is linked to back end database tables in server?

Thank you!

 

[GohDiamond]

If everyone is using the same SINGLE backend; no independent laptops carrying the whole database around; there's no need to synchronize with the backend because its already all the same for everyone. If you've replicated the front end there's no need to synchronize with the design master unless you've made changes to objects that are not tables.

I've been trying to launch the synchronize now command when a user closes/unloads the main form but no luck yet.

The basic command in VBA is DoCmd.RunCommand acsynchronizenow

Let me know if it works for you

During the command there is a dialog box that requests the synchronize point and a browse button to allow you to define the path to the BE or Design Master FE. Sync the BE with the Main BE and the FE with the Design Master as needed.

BTW the Synchronize Now Command is under Tool\Replication\SynchronizeNow...


Goh