FTP only table adds, deletes and changes to central repository 1

[synapsevampire]

Using MS Access 2003

The task at hand is to aggregate data from a proprietary application, which uses a MS Access database with minimal date stamping, and no notion of history throughout.

I assume that some people have addressed this before, and might offer some insights.

We're going to keep the aggregated data in SQL Server, however the task is to distribute a program which could determine what rows differ from the previous day and then xmit them to a central location using FTP.

All input is greatly appreciated.

-k

 

[Remou]

Just a vague idea, how about some of the auditing code that crops up from time to time?

http://allenbrowne.com/AppAudit.html

http://support.microsoft.com/kb/197592

 

[synapsevampire]

Nice idea, thanks.

However I should have elaborated. This proprietary application is not under mmy control, so I cannot add code to it, plus it's a C++ application which might circumvent these methods.

-k