Refreshing Indexes

[Guest]

I'm using Access 2002 and I'm wondering if there isn't a way to refresh all
the indexes to a table?

 

[Craig Alexander Morrison]

Compact the database.

 

[Guest]

Craig,

Is there a way of doing this programatically, say as a form is opened?

Harry V

 

[Craig Alexander Morrison]

As long as the database (that you want to compact) is not open and in use
you can use

DBEngine.CompactDatabase

Check usage in help but basically you need to give it the database source
and the target

You will need to rename the target to the source to continue using it as
before.

 

[Craig Alexander Morrison]

....should have added you will find help on the CompactDatabase (DAO) in the
VB editor (2003).

 

[Guest]

Thank you sir, I can take it from here.