>I have to create a database of over 44 million records which doesnt allow me to create a file size over 2 gigs. Is there a size limit and if so how can i get around it?
>I am using a PIII 600 with 512 meg ram and 80 gig hard drive. It runs on Windows 2000.
>
>I'm sure this has come up many times and if anyone knows the answer can they email me at
>
>gt.software@ntlworld.com
>
>thanks
>
>Gareth
Gareth, you can split the tables vertically or horisontally or use combinations of these methods.
See "The Ultimate Power & Speed of VFP" by Val Matison at:
http://advisor.com/Articles.nsf/aid/MATIV02I myself have a FoxPro app handling about 10 GB of data (and growing) using these methods.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison