>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
``` Appreciate a normal day, it is always better than a bad one ```
Kev