We have an application written in VFP 6 using a MS SQL Server 2000 database that has been in used for several years with all users in the same building. The executable is run from the server.

Recently the client opened an office 250 miles away connected by a 6 MB T1 line and has reported that occasionally, users will find data they entered has not been saved. At times they will get the error message "Table buffer for alias "vmit"_contains uncommitted changes".

They also report that if two users try to start the program at the same time it locks up with a series of errors Program errors: "invalid seek offset", "error reading file", "file is in use by another user."

We suspect that these errors are somehow caused by the 250 miles between the workstations and server, but have not been able to isolate the problem.

Any suggestions as to what we could do would be greatly appreciated.