>Colin,
>
>We are using a table which has an FPT file whose normal size is 45mb - every now and then it suddenly expands to over 2GB
>
>While a ftp can expand very quickly if you're doing replaces against large memo/general fields, VFP can't handle a ftp in excess of 2Gb. So it may well be an OS artifact. What server OS are you using?
>
>You might also consider using SYS(2012) against the table to check its blocksize. The ftp can grow alarmingly depending on the blocksize- e.g. if the blocksize is 32, VFP will allocate 16K per memo even if it only contains "Hello world". Add 100,000 records and your 1Mb of memo field will need a 1.6G ftp.

John

Sorry - forgot to mention that when I delete a couple of records and pack the file in question the FPT size reverts to the original 45mb

What is the ideal blocksize to allocate?