Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Zero size DCX file?
Message
From
17/08/2004 02:51:48
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
 
 
To
15/08/2004 22:53:31
Jill Derickson
Software Specialties
Saipan, CNMI
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00933461
Message ID:
00933752
Views:
15
>Hi,
>
>I have a client whose DCX file is having trouble...and the symptom is that the size of the DCX file is zero. What could cause this?
>
>We can restore the proper DCX and all is well...until the next time.
>
>They have had some electrical problems (common here), but we thought they were fixed. I wanted to check here to see if anyone has seen this problem.
>
>Thanks for any input. j

Well, bad power can do this... ideally you'd want UPSs on server, workstations and switches.

If you can get exclusive use of the database, you can issue VALIDATE DATABASE RECOVER, which will rebuild the structural .DCX index file. You can do this even if the .DCX is deleted i.e.
ERASE MyDB.DCX
OPEN DATABASE MyDB EXCLUSIVE
VALIDATE DATABASE RECOVER
If the database container never changes, one trick you could try would be to mark the .DBC/.DCT/.DCX files as read-only.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform