Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to re-index..

Status
Not open for further replies.
jvega

jvega

Programmer
Dec 29, 2000
1
US
Hi everyboby,
Is there a way to re-index and/or compact an Access table inside an application written in Visual Basic?

Thanks in advance, and Happy New Year
 
Sort by date Sort by votes
To compact the database (not a table) use DAO and the code:

DBEngine.CompactDatabase "source database path", "destination database path"

and then rename the database back to original (also make sure that 1. "destination database path" does not exist and 2. the database is not currently in use).


Simon
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
how to send SMS via free API or other service
Replies
2
Views
386
strongm
strongm
sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
364
Ken01
Ken01
2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
1K
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
302
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
How can i get the Column Index and the Row Index when I click on the ListView? 1
Replies
3
Views
319
sal21
sal21

Part and Inventory Search

Sponsor

Back
Top