Hi Brenda,
Another idea...
You could build a replication service so that each site is kept in sync with a main source. You would need to add two fields to each table: a transaction integer field and a globally unique ID field.
The GUID field allows each record to be identified, wherever it was created. The transaction ID allows you to track how current your database is.
Each site sends created and modified records to the main source along with the last transaction ID it received. The server piece applies the records, depending on the rules for such action, and returns all records between the last transaction ID and the one just completed. The application applies the returned records, and deletes any records that didn't end up with a transaction ID.
Clearly, when the application modifies or creates a record, it must ensure the transaction ID is empty. Depending on your application, this might not be to hard. On the other hand, if DELETE this and REPLACE that is coded all over the place, you still have quite a problem.

>I have an application that is installed at 40 sites. Now we want to unify the 40 sites into a single site. This would be over the South East. Out network repsonse is crap. Thinking about Citrix. Wondering if West Wind can help. Our app is has no efficiencies: there are many Browse windows, go top and bottom, etc. The larges file will be about There are about 70 free tables, the largest will be about 300mb.
>
>Thanks
>
>Brenda