A real puzzler.

You say that the network is Win2000, so I assume a peer-to-peer setup.

There is a limit to the number of "shares" available in such networks. How many workstations and do they share printer(s) or other things?

Is there any possibility that an updating (new record added) workstation has a network card that is set to go to "sleep" (a power-saving feature of newer network adapters)? You can check using ControlPanel-->System-->Hardware-->Device manager then d-click on the network adapter and review its properties. I'd make sure all are set OFF (no power management for them).

Is it possible that the workstations (especially the one with the database) have their HDs set for "Enable disk write caching"? If so, I'd turn it off on all HDs. Again the ControlPanel.... will let you see, this time d-clicking each disk listed.

Is it possibe that there is some error being generated but some error handling is burying/disregarding it?

Are you using TRANSACTIONS?
If so, you might want to try putting a SYS(1104) before the BEGIN TRANSACTION statements.

You might try running with SET TABLEVALIDATE at 0 for a few days to see if the situation changes. Or even at some other value than currently.

Good luck. I hope you make it home.



>[Also posted on VMP board.]
>Hi,
>
>I have a large table, MASTER.DBF, with over 95,000 entries. The network is Win 2000, VFP 9.0, latst VMP.
>
>Some users are only updating data and one or two users may be creating new entries. Periodically (4 times in the last 2 weeks, since I've installed their system, here in Pohnpei, FSM), we have had a problem that the user entering new records is unable to save the entry. The user can log back in and make updates, but from then on no further new records can be added.
>
>We've tried rebooting the user's computer and entering on another computer, but from then on, no new entries can be added until the file is reindexed (we use Stonefield).
>
>Other users can still MODIFY information, just no new entries can be created.
>
>Looking at MASTER.DBF, i don't see any corruption. I don't get any errors on VALIDATE DATABASE. The table has 30 indexes.
>
>I'm using table optimistic buffering. Only 1 table would be updated on a new entry.
>
>Any suggestions/help on anything i can do to prevent this?
>
>Any help/input is appreciated...I'm supposed to go home on Saturday! thanks, j