>>Somehow that makes sense to me. If the robot app is accessing DBF data on the web server, moving it to another box would add complexity to the data connections.
>>
>>When is this supposed to move to SQL server?
>
>Two months, but we cannot wait. This is locking down our production server about once every two days now.
>
>Well, I am curious to know why accessing data over the network would cause data corruption. I am looking for a clear explanation on this because this is something I have not experienced so far.

I seriously doubt that they would experience data corruption with their SQL Server robot. I understand that it is common to have multiple SQL Server instances across many systems hit the SAME data on some single (probably fancy-dancy RAID) system. Designed into SQL Server I believe.

But maybe they know they have a flakey network. Almost sounds like it, since they seem to insist that both yours and the robot's data must be on the same system.

But why cannot they move the data too? HDs are VERY cheap these days. Even RAID can be done cheap these days.