Temporarily disable a multifield index?

[datsyuk]

Is there a way to temporarily disable a multifield index? I have a button on one of my forms that is used to update a number of records at once. This update is accomplish through using VBA and the updated field is a date value. In the process of updating values there will be duplicate values at a point but no duplicate values once the update is complete (ie. if the date is moved forward a day on one record, this may be indentical to another record until the code loops through to update that date a day forward as well). The code works as intended when I turn off my multifield index; however, when it is on, it will not run. Is there a way that I can temporarily disable this multifield index while I am running this code and then reenable it?

Thanks!

 

[dhookom]

I think you would need to use code to drop the index and then recreate it. Have you considered adding some seconds or minutes to the dates so they are unique?

Duane
Hook'D on Access
MS Access MVP

 

[datsyuk]

Adding minutes or seconds is not an option in this case. How could you use code to drop the index and then recreate it?

 

[dhookom]

I would type 'Microsoft Access drop index' into my favorite web search engine and find the code. I would then add the code to a test/sample/sandbox database to figure out how it works. Once I was comfortable with the code, I would implement it in my production environment.

Duane
Hook'D on Access
MS Access MVP