>We are designing a system that will be n-tier using web-technologies for UI, MTS, and SQL Server 7.0. However, I'm not sure of the best way to handle one situation. We have users all over the world that need access to the data. Sometimes they may not be able to dial in or the connection may be bad and we need ti insure that the data is accurate. How is the best way to handle this? Obviously we will need to somehow keep remote copies of everything up to date...web pages, data, etc.
How is the remote data going to be hosted? All on SQL Server? VFP tables (I'm assuming only SQL Server, though)? Mixed environment? If you maintain a copy of the data, is it going to be on a single system, or a server at their site? I haven't had a chance to use it, but I'm sure SQL Server supports database replication.
-Paul