VBA Code to start Active Sync

J

Japheth

I have an Access database that I want to sync with my Pocket PC. I need some
code that will start Active Sync. In other words after I am done updating
some records with VBA I want my Pocket PC to automatically sync by me
starting the sync process with VBA. Does anybody have tips?
 
L

Lance McGonigal

You should be able to Shell() or App Activate. Yep, that's how I'd do it.

Cheers
 
J

Japheth

Active Sync should already be started and will have synced when I connected
the device. But how do I get the sync process to start again to get the
latest changes?
 
L

Lance McGonigal

If there's no api then the only thing I can think of is to do a sendkeys to
the app. You'd have to make sure the app is running then send a key combo
to it that would start the sync.

Cheers
 
Top