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!