Deactivate Indexes

[Dominic]

Hi
Is it possible in Access 2000 to "deactivate" indexes?
I am developing a data pump procedure to import data from an ODBC source
into Access for reporting. The logic is that the tables already exist in the
Access database an on import the tables are just emptied and the data
re-imported.
Since we are talking a lot of data in some cases, I would prefer if all
indexes could be made inactivate so the inserts run faster and then then the
indexes were reactivated after the import was finished.
I know that some RDBMS's supported deactivating indexes for just this
purpose, eg
ALTER INDEX INDEXNAME INACTIVE;
and was wondering if access supported something similar.
Thanks
Dominic

 

[Allen Browne]

No. You have to DROP the indexes, and recreate them.
It certainly can make a difference for importing large quantities of data.