Is there a chance that one/more of your tables includes a field with the
"lookup" data type? I believe Access "automatically" adds an index if you
use this type of field.
Good luck
Jeff Boyce
<Access MVP>
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.