Maybe you could change your append/seek/go/replace/etc syntax to use the more multi-user-friendly, like using SQL-Select and SQL-Update.
Maybe you could take when your desktops are inputting and have them first input it locally on their system, and then copy the DBF to the central system where a single EXE on the server does the actual data updating.
Also, why are you using row buffering instead of table buffering? It seems like row-buffering requires much more impact on the DBF header than table buffering.
>Hi,
>I have a VFP 6.0 laboratory system for grain samples. Tha lab is collecting data about weight, water%, protein etc. It is quite simple with one main DBF. This DBF is FOX2x as I need to read data from another program. There are 10 PCs adding record and updating the file. The volume is about 1500 new samples every day added from 2 of the machines and 3-5 updates on these records from the other PCs. Input is mainly from bar-codes and online weights.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only