>I used the CLOSE ALL command....then I OPEN MyDatabase EXCLUSIVE......then I used the VALIDATE DATABASE RECOVER......I was prompted "Do you want to create a backlink from MyTable with the MyDatabase"....I clicked yes.But I can see on the console that the table is not found in the database..I already added the table in the database but still cant...I am lost.
Open the database and run the GENDBC program found in HOME() + [Tools\GenDBC] folder. This will create a PRG file of all the code needed to re-create your database including the tables, indexes, RI, SPs, etc. Create a backup folder and move all your current tables, DBC and indexes into this folder [or rename this data folder to DataOld and create a new folder with the same name as your current data folder]. Copy the PRG file and the KRT file created by GENDBC into the Data folder and run the PRG file from this data folder to re-create the database and all the objects assiciated with it. The KRT file will be the same filename as the PRG name you specified for GENDBC to create.
You will now have a new, uncorrupted database with the tables, indexs, RI, SPs, etc. Open each of the newly created tables and APPEND the data FROM the tables in the backup folder. If any table did not get recreated, open those tables in the backup folder and do a COPY TO \DataBasePath\MyTable to create a new set of data files. Add the table to the DBC and recreate any indexes, PK, etc.
Mark McCasland
Midlothian, TX USA