>Unfortunately I have encountered a situation where a customers data has 2 views with the same name. When my reindex code runs it also packs the DBC where it faults causing the DBC to become completely corrupt as if it was not already.
>
>has anyone encountered this problem before... and if so....how are 2 views with the same name in the DBC.
>
>Thanks in advance
The only way I can think that 2 (or more) views with the same name could get into the database is that the DBC was USEd and records were RECALLed.
When you re-create a view, the existing view is deleted and the new one is added. Since the DBC is a table, these records are still there, just marked for deletion.
Any code, or over-ambitious user or developer <g>, USE the DBC?
Insanity: Doing the same thing over and over and expecting different results.