I have a client who needs a mobile Access solution. So we are going for an Access 2002 Project with MSDE.
Each laptop will have Access 2002 and MSDE on.
Periodicaly they will dial into the network and will need to syncronise with a back end SQL server (publisher).

Anyone know the best to fire this event off. I cant seem to find any code or examples.

What I was thinking was a button on the main switchboard which they can click and fire off the syncronisation when the network is available.

Any ideas etc much appreciated