We have a client using a VFP7 app with a shared data folder on the network. Actually they have two locations using the database, one in Florida and the other in California! Last night they had a power failure in the FL location (where they have the database), and even though they have UPSs, they said that the connection to the VFP app was lost (their email and most of the other apps kept running). Anyway this interruption corrupted the indexes.

This morning they sent me their data folder and I repaired the files and sent them back. However, they weren't able to replace their data files because the current files were open (they think by hung apps that were using the software when the network went down). I told them this is an OS issue as Windows will not let them over-write files while in use, so they need to either disconnect their server from the network or have users reboot their computers to make sure no hung apps are using the database. They said either solution is disruptive and they don't want to do it. Instead, they want a 'back-door' to get into the VFP software and tell it to 'kick every one out!'. Any ideas?

Also, does anyone have a good strategy for dealing with this data corruption problem which seems to occur everytime a VFP app is improperly shut-down? It seems to me the only way to stop this big problem is to convert the VFP app to a web app or use SQL server. Neither solution is easy to do.

TIA.

Mon