It sounds like one of your tables is getting too big. You could look at splitting the table on some field - like year if it has a year field. You would need to check your code and maybe write a method to determine which table to access when queried or updated.
I have a VFP database that is about 40 GB in size. It has a lot of split tables in it and it actually outperforms SQL Server. -Charlie Sent from my DROID! ----- Reply message ----- From: "Kent Belan" <[email protected]> Date: Thu, Jul 15, 2010 8:40 pm Subject: Large Data Tables To: "'ProFox Email List'" <[email protected]> Hello, I have a client that has been going along great for the last 10 years. He is now ready to explode. We are pushing the 2 gig limit now on the client table and he wants to add tons more. What do you recommend to solve the table size limit problem ? I know the answer is probably SQL server but I have never programmed to access SQL. I am guessing that this is going to be a huge job to covert the app from DBF files to SQL server. Has anyone converted an app from DBF to SQL access ? Do I have to convert all the tables from DBF to SQL or can I just convert the client table and maybe a few others like transactions and payments ? I wish I had used business classes, it would have been much easier ... Thanks, Kent _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/249568a459914a2685c59fd558fc2...@kentlaptop ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

