>Hi,
>
>>Have you tried recreating the indexes as opposed to using REINDEX? REINDEX can leave corruption.
>
>Yes. Following maintenance command is used:
>
>1. Copy table contents to temporary dbf file.
>2. Use create table command which I posted to create new table.
>3. Convert created table to fox 2 format using copy to .. fox2x
>4. Add customer-specific columns from data dictionay table (if exist)
>5. Append data from temporary file created in p.1.
>6. Clear code page in dbf header using MS cpzero
>7. Run index command which I posted.
You can create a temp dbc and then in step 1 "copy ... to {tablename} database {temp dbc}", so step 3 becomes unnecessary and you don't lose long field names.