>Hi Ed,
>
>Is there someway to clean unreferenced information in the dct? We are using Stonefield, but that seems to primarily deal with the structure of the dbc and not the content of the fields. I tried opening the dct through vfp, but it did not like that. Do I need to view the dct data through the memo fields of the dbc?
>
Since virtually all the data is in the memo fields, and the .DCT is where the memo data resides, your best bet is to open the .DBC as a table exclusively, and then pack it and the memo fields (make sure you have backups of the DBC first, of course.) If you have a DBC called MyDB.DBC, try:
CLOSE DATABASE ALL
USE MyDB.DBC EXCLUSIVE
PACK
PACK MEMO
USE
FLUSH
OPEN DATABASE MyDB
and then call the SDT method to validate and update the DBC from the metadata.