Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Enhancing Limit of DBF tables Over 2GB
Message
 
 
To
02/04/2013 10:07:51
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01569690
Message ID:
01569742
Views:
87
That uses the Advantage database, not FoxPro DBFs. Which may make Advantage something to consider for those grappling with the 2 gig limit and not wanting to move to one of the popular databases. (Personally, in 2013, I can't imagine why).

>Sir,
>While Searching on Google I found some Information on how to increase the data size over 2GB, but dont have still Evaluated that. Here is the link.
>
>
>http://devzone.advantagedatabase.com/jeremym/fox_large/foxprolarge.html
>
>
>AND
>
>
>http://devzone.advantagedatabase.com/dz/webhelp/advantage10/index.html?devguide_connecting_to_advantage_using_the_advantage_odbc_driver.htm
>
>-------------------------------
>
>
>
>>>Is there any simple way to enhance the Limit of VFP DBF table beyond 2 GB Capacity ?
>>
>>Follow a few round rules, and this will not be any problem for a normal size application.
>>
>>1. Never use general fields. NEVER!!!
>>2. Never store pictures in tables, only the name of the picture file, with or without path
>>3. Normalize the tables, don't add fields which are seldom used.
>>4. Reuse deleted records
Previous
Reply
Map
View

Click here to load this message in the networking platform