How do I automate synchronization with a macro or VB code?

I've set up a VPN and created a mapped drive P:\ where I put the Design Master file for my database.  I have computers at several locations throughout New Orleans that have indepdent local versions of my database on their machines.  Each one has a mapped drive P:\ so they can access the Design Master database for synchronization.  I want to set up a macro to automatically synchronize with the Design Master every time someone starts the database.  I tried looking under the "RunCommand" options in MS Access Macro designer, and found a command called Synchronize Now.  But, when you run the macro it pulls up a "Synchroize Database window and it has 3 radio buttons "Directly with Replica:", which is the only option that isn't greyed out, and "In the background with all synchronizers, and In the background with synchronizer (both greyed out).  Each time you have to click OK and click YES to close the database to begin.  I want it to be an automatic thing when people open the database, because my users are kind of technically challenged, and plus I'm not sure they'd remember to do it.

Anyone know a way to write a VB function to do this on open of the switchboard or is there perhaps a way to set up a simple macro to do this with the necessary parameters to tell Access where the file it's synchronizing with is located?

Thank you!Start Free Trial