General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi David.
>I have a table with a corrupted CDX file. If I try to USE the table, it won't open because it needs the CDX file. Is there a way to open a table without its automatic CDX file, so I can reconstruct the indexes?
Is this a table in a database container? If so, you can delete the CDX, but should then do a VALIDATE DATABASE RECOVER (which you can only do from the Command window, not from within a program) to correct the DBC or you won't be able to open the table. Then, recreate the indexes using the Table Designer or a combination of ALTER TABLE (for the primary key) and INDEX ON (for all other indexes).
Note: if you need to do this at a client site, it'll be very difficult, since VALIDATE DATABASE RECOVER can't be used in a runtime environment. You might want to check out Stonefield Database Toolkit for a tool that can do this (and a lot of other things, like repairing corrupted table and memo headers and updating table structures) in a runtime environment.
Doug
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only