>Why is it that Visual Foxpro claims to have no limitation to the size of fpt files for memo fields,

Uh, we've never made that claim. The limit is 2Gb.

> but yet when one of them we use goes over 1 GB, it only runs stable for a >few minutes after that, then the fpt looses a lot of info. Random blocks >of data disappear from random accounts.

More details, please. OS? Networked or local? Multi-user?

RE: OK, maybe it it was memo fields that had a 2 GB limit. But we run the program on a Novell network server, multi-user and Windows 98 workstations. I am not sure why any of these factors would matter as to loosing data from the table shortly after going over 1 GB if the limit is 2 GB. It performs fine up until the point it gets over 1GB or slightly over then we start loosing different blocks or whole records worth of data from the FTP. I have taken measures to split the table into two archiving some of the info to prevent this, but looking to future expansion, I would like to have an idea why this occurs.

Kev