>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.
Server is Windows 2003
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing