I am working on a multiuser VFP 5 application with some fairly large dbf tables (50,000 - 1,000,000) records. About 2 to 3 times per month and seamingly at random, primary key values are being corrupted. This corruption consists of a CHR(26), Ctrl+Z, byte overwriting a byte within the primary key field. Although I have noticed the CHR(26) at various offsets within the primary key field it seems to occur preferentially in the second byte of the field. This is true for key fields of both data type Character and Integer.
Has anyone had a similar experience. If anyone knows what might be causing this I would appreciate hearing from you. I've searched the Microsoft knowledge base to no avail.
Thanks,
Lister