Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
2 Gig
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: 2 Gig
Miscellaneous
Thread ID:
00680293
Message ID:
00680307
Views:
19
After making a backup of the file, and then another one in a different place

Take a copy of the file and you can use the LLFF to manipulate the header of the file to lower the number of rows (N) in the file to the point where headersize + N * recordsize be be something less than the 2gb limit. Then you'll have to use to truncate the file to the size. You can use the DBF file structure documentation from the help file as a guide to where the number of rows is stored and how to determine record size and header size.

>We have a dbf that is too big. How do you open it when it won't open.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform