Hi
Using triggers in database you can log inserts/updates/deletes to log tables.
I've done something like this, but we needed that local tables to be in sync with server side tables.
Log tables have the same structure as base tables with extra columns like tr_id (autoincrementing integer PK), tr_type (can be "I","U" or "D"), timestamp and user info columns, etc.
Then is easy to download only transactions from the last id, saved locally, and then apply changes to local tables.
Maybe you ca use the same idea but updating server tables.

Dorin

>I need some help thinking through a sticky syncing problem.
>
>My company has a commercial software package Mailorder Manager (MOM) based on a VFP 5.0 database (there is a new version based on VFP 8.0 that we have not upgraded to). We do not have access to MOM’s code.
>
>Online, we use an online shared SQL Server 2000 in which we cannot be given admin rights. Thus SQL replication is not possible.
>
>We are hoping to have "almost live" inventory levels online based on the inventory levels in our local MOM VFP Inventory table. These local inventory onhand levels change throughout the day as we do retail and mailorder along with web orders.
>
>Our local VFP table does not have a time/date stamp. Thus we do not know what records have changed.
>
>Can someone point me in the right direction for syncing and automating this process?
>
>Thanks!