Thanks Gregory
I couldn't wait any longer as I had to get on, so ended up removing the table from the dbc and then I could edit it. So back to square 1 and building the index, long table attributes, rels and RI all over. Luckily it wasn't involved in more than one rel.
I'll bear your suggestion in mind for the future.
Still any more suggestions out there, to save my doing this all over again?Terry
>Terry,
>
>This is worth trying
>
>Restore the cdx file from a backup
>Open the table exclusively
>reindex
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.