Hi Just was changing some information on a table file with a few more field, when the program hung. When I went back in the system now says "Table file WORKCAAG.DBA not found - 1" is there a way to sort the problem as i am unable to access any records for my business. 

Regards Brent 

Hi Brent.

The data is still there in a Temp Form XXX table. The problem is that the change crashed in the middle of changing the table.
The way this happens is:
1. The existing table is changed to Temp Form XXX
2. The new table is created with the changes and named the original name.
3. The data is transferred from the old table to the new table.
4. The old table named Temp Form XXX is deleted.

Your problem is that it crashed in 2 so in RDRR the table is the one that could not be created and hence its missing the file.

For most users this is a classic go back to last Backup situation.

If you don’t have a recent backup you need to manually edit the RDRRxAAA.RDR (or DBM if the application is older than 8.5).

1. Take a copy of the application before you start.And make sure nobody use the application when you edit the RDRR file.

2. Download/find hexedit.
You can use the online version of hexedit found here: https://hexed.it/

Each table will have a record in the RDRR file. So to fix your problem you simply change the filename on the entry which is now missing it.

3. Search of the Temp Form that has the definition and data. In this sample that is Temp Form 84.

When you search for it make sure it is marked with 0E, three positions in front of the table name. 0E means it is active and 0F means it is deleted.

Copy out the Filename and mark the entry 0F (this will remove it from the table list). You can also simply delete it in the Catalog after you have successfully completed the fix.
4. Search for theTable Name that is missing its definition. Let say this is Barcode (in this example).

Again check if it say 0E in front of the table name. You might have many entries for the same table so make sure you use the one with 0E in front of the name.

As you see from our example the difference in filename is simply one letter so we edit thsi and save the RDRR file. 

Now you can see that the correct file is mapped to the correct entry in RDRR and you can open your application and everything should be fine.