H
Harry V
I'm using Access 2002 and I'm wondering if there isn't a way to refresh all
the indexes to a table?
the indexes to a table?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Craig Alexander Morrison
Compact the database.
H
Harry V
Craig,
Is there a way of doing this programatically, say as a form is opened?
Harry V
Is there a way of doing this programatically, say as a form is opened?
Harry V
C
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.
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.
C
Craig Alexander Morrison
....should have added you will find help on the CompactDatabase (DAO) in the
VB editor (2003).
VB editor (2003).
H
Harry V
Thank you sir, I can take it from here.