>After 3 years windows explorer reports that PHOTO.FPT has grown to a 995 Meg size file. Is there an upper limit to the size of an FPT file? I am well below the record limit for the parent table PHOTO.DBF but the size of the fpt is starting to concern me. Also… last night the FPT became corrupted. Any file can become corrupted but I am wondering if I am sitting on a time bomb.
I never stored images in a memo field. Same here on UT where I store everything on the disk with a proper relationship with the record in the table. As mentioned recently, yes, it can be a problem when you have to maintain those records, such a deleting them, by having some kind of mechanisms to do the cleanup on the disk as well. But, using that approach, I never had any problem.