Hi, Michel.
>We have very large table. We are very close to the limit of FoxPro (2GB). Soon we have a project that will make that table will be bigger. We are thinking about partioning data or use codebase. We want to make the best move. I wish I can have the opinion of people who did the same move before.
As Nick said, this can be done. The most famous example of this was the Eurotunnel application, although I don't know if it is still running.
Going to CodeBase, in any case, would require a major rewrite of you application, as the usage differs a lot from the regular VFP internal manipulation. And I didn't have very nice experiences with CodeBase, although it has been a long time since I last used it.
If rewriting your application data access is not that difficult (maybe you have a properly isolated data-tier), then you can consider going to SQL Server or any other relational database engine. This would not only provide a higher capacity, but also higest security, better consistency, etc.
My two cents,