>I get an error when trying to open my dbc that the index does not match the table. It tells me to delete the index file and re-create the index.
>My question is how do I do this properly? I'd hate to delete my .dcx and then be screwed. How do I re-index a dbc? Can someone confirm the procedure so I get my database back? Thanks in advance.
>Allen
Luckily, A dbc only has a couple of indexes to begin with. YOu probably should avoid REINDEX, because the info in hte header could be corrupt and you could just get another funky index. Make a backup of your dbc and do issue the following:
USE MyDBC.dbc EXCL
DELETE TAG ALL
INDEX ON STR(parentid)+objecttype+LOWER(objectname) TAG ObjectName
INDEX ON STR(parentid)+objecttype TAG ObjectType
And that should do it.
Erik Moore
Clientelligence