>>How much RAM do the 98 machines have?
It is PII with 128MB RAM. Server is mapped with some letter (G:).

>>What happens if you delete the cdx files and recreate them from scratch?
Nothing.

>>Is write cache disabled on the hard drives?
I did not check that.

>>Can you post your code? (The select and the update code)
This is code for creating report. Code is

SELECT A.Field1, A.Filed2, A.Filed3, A.Filed4, A.Filed5, A.Filed6,A.Field7,;
B.Field1, B.Field2, B.Field3, B.Field4, B.Field5, B.Field6, B.Field7, B.Field8,B.Field9, B.Field10;
FROM Table1 A, Table2 B;
WHERE A.xx = m.Variable1 AND A.yy = m.Variable2 AND A.xx = B.xx AND;
A.yy = B.yy AND A.FieldX = .F. AND B.FieldY = .F.;
ORDER BY B.Field5;
INTO CURSOR XX

REPORT FORM XX PREVIEW


>>Is this a peer-to-peer network and no other network is involved?
Yes, No other networks.

>>Are xp users updating the tables at the same time as 98 users?
Yes
>>Are ANY of the files (.fpt, .dbf., .cdx) anywhere near the 2GB limit?
No

>>Whatis the OS where the tables are actually stored?
XP