Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Uhh ohh...table over 2gig - can we open it?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00804445
Message ID:
00804709
Views:
48
Victor, check VFP help under Table File Structure. This will show you what the header of the DBF file and FPT files look like. You can then get the info you need iro SB's idea.


>hmmmm...interesting idea ... but since VFP won't open the table I'm not going to be able to use the Header() and RecSize() functions.
>
>>Here's an untested idea. Using formula
nLogicalSize = HEADER() + (nRecCount * RECSIZE()) + 1
find the size closest to 2GB but less than that. Use FCHSIZE( ) function to change your table size to that. After that you may try to fix table. As usual, make backup before trying anything. :)
>>
>>>Well I've tried FoxFix, FixFoxPo, FixFox, dSalvage, ATFixDBFPT, smREpair, SalvDB and VFPvw. Anyone have any other ideas?
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Reply
Map
View

Click here to load this message in the networking platform