FTI Data Replication Tools
Fleet Technologies, Inc. has developed a set of tools that enable client applications to collect and distribute data from disparate Access databases to a “master” Access database on a shared disk. While true Access replication addresses these needs, it is difficult to implement for the average user. Furthermore, we have found that many networked applications collect data for analysis and reporting purposes only. They neither require nor benefit from the more complex features that standard Access replication uses.
Our tools address the following scenario. An application collects information from a user during the normal course of operations. This application is installed on multiple “client” machines on a network, and multiple users execute this application during the course of the day. A user might have access to any of the client machines on the network. The data on each client machine needs to be collected into a remote master database for reporting and analysis. Furthermore, the database on each client machine may periodically need to retrieve data from the master to stay synchronized.