I've written many FoxPro and some Visual FoxPro apps over the past 10 years. One Client has been getting Ghost record locks ever since they switched onto a MicroSoft Network, first WWG, then Win95, now Win95 PCs with an NT Server. I always code RLOCK() before READ, and on this particular system, it will give a record lock error, even though the record was just created. I have many particulars, but nothing I or they have tried has made a difference.
Most people have two records and GETS on the screen. When someone creates a new record, the program does INSERT INTO, then saves RECNO, UNLOCK, USE (Close), then USE EVNT to reopen, then GO, then the GETS, then RLOCK() and READ. It works a thousand times a day, until someone's work station locks all records. Then the INSERT INTO works, but they can't lock the newly created record. They all log off. Where should I look?