>Hi
>I got a project that done by other programer (unaviliable now).
>
>The database is very huge.
>
>I started to explore it and I seen the biggest file size is .fpt - memo.
>I went inside and I found that the maximum len is 67 (almost 80% len is 11), in addition, this is not sorce for edit box, it's only log field that base on other table list with few options and the maximum lenght could be 67.
>
>I prefere not to change the field type and my question is if there is a way to short the size (I remmenber something about SET BLOCKSIZE but I never used with this).
>
>In addition, I look for other tips/tools to help me shorting the database (it's more than 3GB after 4 years use).

Hi Chaim,

Read the following thread Revisiting the 2 Gig limit Thread #1121213, it may give you some ideas.