 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / July 2006Refreshing Indexes
I'm using Access 2002 and I'm wondering if there isn't a way to refresh all the indexes to a table?  SignatureHarry E Vermillion IT2 Division of Wildlife State of Colorado Compact the database. SignatureSlainte Craig Alexander Morrison Crawbridge Data (Scotland) Limited > I'm using Access 2002 and I'm wondering if there isn't a way to refresh > all > the indexes to a table? Craig, Is there a way of doing this programatically, say as a form is opened? Harry V SignatureHarry E Vermillion IT2 Division of Wildlife State of Colorado > Compact the database. > > > I'm using Access 2002 and I'm wondering if there isn't a way to refresh > > all > > the indexes to a table? 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. SignatureSlainte Craig Alexander Morrison Crawbridge Data (Scotland) Limited > Craig, > [quoted text clipped - 7 lines] >> > all >> > the indexes to a table? ...should have added you will find help on the CompactDatabase (DAO) in the VB editor (2003). SignatureSlainte Craig Alexander Morrison Crawbridge Data (Scotland) Limited > Craig, > [quoted text clipped - 7 lines] >> > all >> > the indexes to a table? Thank you sir, I can take it from here. SignatureHarry E Vermillion IT2 Division of Wildlife State of Colorado > ....should have added you will find help on the CompactDatabase (DAO) in the > VB editor (2003). [quoted text clipped - 10 lines] > >> > all > >> > the indexes to a table? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.