synapsevampire
Programmer
Using MS Access 2003
The task at hand is to aggregate data from a series of installs of a proprietary application, which uses a MS Access database with minimal date stamping, and no notion of history throughout. I cannot add or alter anything within the app.
So my thought is to add another Access database and use queries to determine the differences, and then xmit changes via FTP to the repository.
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
The task at hand is to aggregate data from a series of installs of a proprietary application, which uses a MS Access database with minimal date stamping, and no notion of history throughout. I cannot add or alter anything within the app.
So my thought is to add another Access database and use queries to determine the differences, and then xmit changes via FTP to the repository.
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
