> See REINDEX. But my point was that there may be undetected
> corruption.
> If I were you I'd not rely on REINDEX to prevent all problems.
Indeed; REINDEX neither detected nor fixed the corruption.
Thanks for all your help; we'll recreate the database as soon as we can.
Many thanks,
Chris Purcell