I have a friend who has asked me to urgently help/ code a new update process on his business database:
He wants the database to quickly and efficiently automatically update when users log on and export data when they logoff. The database is not split (and he doesn't want it to be), so each user has their own database and as they will sometimes be in their clients houses they cannot always have access to broadband.
I am thinking of a replication farm on a VPN, but this really is outside my knowledge.
can anyone help with suggestions and code examples(if neccessary)?