Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
.DBF files disappearing
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00708521
Message ID:
00708527
Views:
9
>DBF tables within a database have started disappearing from a client's network.
>The configuration is VFP 5 runtime, W2000 sp1 on the workstations and server.
>The client has ruled out modifications to the network, workstation, cabling, virus, user error, etc.
>Although we haven't run the program in debug mode we are relatively confident that the PACK command is failing.
>The application is stable and has not been modified.
>There is over 2 Gb of space on the 'C' drive of the workstation running the application and about 19 Gb on the mapped server drive.
>The DBF is 8.06 Mb, CDX is 948 Kb and the FPT is 163 Mb.
>I would appreciate any other ideas before I suggest that the client have a third party run network and hardware diagnosis (big $).

If you truly suspect the native PACK, you might suggest the client purchase Stonefield Database Toolkit (you want version 5.1J for VFP, not the more recent versions for VFP6/VFP7.) Once you've run the Database Explorer of SDT against the DBC and any free tables, you can then use either the Database Explorer's Reindex button or the REINDEX.PRG that acts as a wrapper on the SDT classes to reindex and pack (you can either reindex or pack and reindex by altering a parameter passed to REINDEX.PRG when it is invoked.)

If this solves the problem, I suggest that you then replace PACK and REINDEX operations in your app with invocations of the SDT runtime classes, provided with SDT.
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