About this Article:
This tipster often removes indexes on several Access tables prior to importing the most current data from various text files. Through trial and error, he has found that his data imports execute much faster on non-indexed tables. After the data has been imported, he re-creates the indexes via code. This all happens automatically in an overnight batch process, which sometimes fails due to network issues. The need arose to check the existence of the indexes prior to attempting to remove and re-create them. Here's the code to do it.