Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Huge VFP 3.0 files
Message
From
05/05/1999 12:45:52
 
 
To
05/05/1999 12:32:18
Mark Pagano
Marathon Ashland Petroleum
Findlay, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00215105
Message ID:
00215399
Views:
32
>The .DBF file, using DOS, has a file size of: 1,114,112.
>
>Using the formula: RECCOUNT() * RECSIZE() + HEADER() + 1 in the VFP command box, I get a file size of: 80,075.
>
>Any other suggestions?
>

I've seen this in situations where the indexes of an NTFS volume became corrupted. If you can open the table safely under VFP, open it, copy to another table and close both and shut down VFP. Then run CHKDSK /F against the NT volume holding the file (this likely will be deferred to run after the system is shut down and restarted) to force NT to validate and repair the NT disk volume involved.

>Mark
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform