Reply to thread

Message: [QUOTE="Rick Brandt, post: 2560484"] SQL Server only solves the problem of the unreliable WAN connection corrupting your data (as it would almost certainly do with an MDB back end). It will not make performance any better. Your performance problems are caused by how long it takes to pull the data over the WAN connection. Using SQL Server doesn't magically make that problem go away. Didn't the "test period" take into account the fact that the fastest WAN is still 10 to 100 times slower than a pretty crappy LAN and thousands of times slower than a really good one? You should either create a web-based front end for the data or look into a remote (thin client) solution like Terminal Server. [/QUOTE]