If the index is corrupt, Access may delete it during a compact. The
important issue is to try to find what is causing the corruption.
See:
Preventing Corruption
at:
http://allenbrowne.com/ser-25.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mark Cohen" <ma****@opro.com> wrote in message
news:87**************************@posting.google.c om...
I have a database where indexes regularly go missing. It is repaired
and compacted daily apparently without any problems. I have already
imported the tables into a new database but the problem persists.
Does anyone have any ideas?
Thank you