Doug,

Never mind...I found it. Strange setup it is for sure. But, the bottom line was that SDT's validation process was deleting records from Sdtmeta.dbf and coremeta.dbf that were not found in the DBC. Sounds reasonable and correct. I just didn't realize what was happening...recalled all and life is good again.

Thanks!

Scott

>Doug,
>
>Thanks for that information. I changed all the settings on the properties page and SDT 5.1j still validates when it opens?
>
>Anyway, I have another question for you. I have an external EXE that does nothing but reindexes and packs the database in an EXE. The program is simple:
>********************************************************************
>PRIVATE oMeta
>
>CLOSE DATABASES ALL
>ON ERROR RETURN
>OPEN DATABASE DATA\#SMART EXCLUSIVE
>
>
>oMeta = newobject('DBCXMgr',"DBCXMGR.vcx")
>*!* oMeta = NEWOBJECT('DBCXMgr', 'DBCXMGR.VCX', '', .F., JUSTPATH(DBC()))
>
>IF TYPE('oMeta') <> "O" OR ISNULL(oMeta)
> =MESSAGEBOX("Stonefield Meta Creation Failed!",16,"Program Failure")
> RETURN
>ENDIF
>
>LOCAL llRetVal
>
>llRetVal = .F.
>
>llRetVal=ometa.setdatabase(DBC())
>llRetVal=ometa.osDTMGR.reindex("ALL",.T.,.T.)
>
>IF NOT llRetVal
> =MESSAGEBOX("Pack/Reindex Failed!",16,"Program Failure")
>ELSE
> =MESSAGEBOX("Pack/Reindex Completed Successfully!",64,"Program Success!")
>ENDIF
>**********************************************************************
>I have the two Stonefield classes included in my project. When I run the EXE, it only reindexes and packs the first table in the database? There are over 35 tables in the database. This is the project I inherited and the reindex/pack that was inside the application was doing the same thing, so I thought I'd write an external program to do the same thing. Where should I be looking to overcome this problem?
>
>Thanks a WHOLE BUNCH!!!
>
>Scott
>
>
>>Hi Scott.
>>
>>>One question though...when I select the Stonefield Database Explorer from the menu, it automatically starts validating the above-mentioned dbc?
>>
>>In the SDT Properties dialog, select the Open Database Explorer with no meta data setting.
>>
>>Doug