Don't know if pcAnywhere has an API you can hook into but we do it with a DOS based coms system using db files and in-house applications. With any replication scheme you need some mechanism to deal with conflicts. You could use Midas and Client datasets. You could roll your own scheme - as we have done (because the replication is one-way). You could have a look at the Interbase replication engine if you use that. Or MS SQL's. Even Windows Briefcases may be possible - which in conjunction with Access will give you fairly basic conflict resolution. "Patrick Dunford" <[EMAIL PROTECTED]> on 02/05/99 23:23:14 Please respond to [EMAIL PROTECTED] To: Multiple recipients of list delphi <[EMAIL PROTECTED]> cc: (bcc: Peter Jones/Logistics&Information Technology/Christchurch/Foodstuffs) Subject: [DUG]: pcAnyWhere & Remote Updating of Databases Has anyone done a project like this? Is pcAnyWhere limited to downloading the complete database files and uploading them so a program on the server can synchronise, or is it a bit more sophisticated than that/ How do you synchronise say three remote clients that all dial in at different times and might have all changed the same record since they last downloaded? ============================================ Patrick Dunford, Christchurch, NZ http://patrick.dunford.com/ --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz