>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