I have a VFP7 client application running on about 3 PCs (W98SE / WXP) against a shared VFP database located on a server within a large client network. Occasionally one user will run a program within the application to pack and reindex the data files within the database. To do this, of course, they request other users to sign off and then acquire exclusive use of the database and tables. The routine checks for exclusivity.

Recently, this has caused several C5 crashes, probably at the program line that contains the command 'pack'. Upon then looking at the database, a dbf file has vanished (leaving its cdx and fpt files). This is at the least inconvenient(!) - at the most, potentially disastrous, as the system feeds the main factory trailer loading pallet picklist.

It is possible that at the point that the routine is run, there is a mismatch between the cdx file and the dbf file (how can this happen?), but I am not sure.

Any ideas?

Mike