>It will have to be tested in the environment. A simple app should do it. There are load testing apps that will show you what you're getting. Keep in mind the the hadware/OS/IIS setup should mimic the production system. However, no matter how many users, I would not trust the VFP OLE DB provider to work properly on the web. It only takes one time that a critical table doesn't get updated properly.
More or less, that's why I only use it for synchronization because the accuracy can be verified. And, for what it's worth, in practice I am only copying a files from one format to another, no indices involved at all. My gut feeling has always told me that would be really asking for problems. I'm happy if I can just get the files transferred accurately, I have low expectations.
Scott Ramey
BDS Software