VBA to force Windows Sync to Run

[mikebrewer]

Hi all,

I have an application that is using SQL Express as a backend and syncing to a SQL database through SQL web synchronization. This all works great and my clients have my custom application to interface with their local database and do work and it syncs back to the corporate database and I've got it scheduled to run in Windows every minute. What I would like to do is have a button or on event set of code that forces that sync pairing to run and I'm not exactly sure how to do that. Does anyone have an idea? I've googled around for it but so far I've come up with nothing.

 

[spikepl]

I am not too sure about this at all, but I note that you are able to force a sync using the windows scheduler? So you have a script that runs, right? You could run the script from a separate process, spawned by Access using Shell - google Access vba shell

 

[mikebrewer]

Well kinda... I am just using tools that are available in the Windows Sync Center and you can schedule it there. I'm not sure how to programatically make that run. I don't have a script that runs. Its a function built into the Windows Sync Center.

 

[spikepl]

If you can run the sync center from command line then that's all it would take