Compact and Repair Database

[yhgtbfk]

My database is going to be limited, and practically has no menus.

How can I do the following with the help of visual basic?

When you click on a text button it compacts and repairs the database. (I had a look in the help file but the help page describing this was missing !)

Thank you

 

[RichO]

I found this by searching the forum:

This piece of code will execute Compact & Repair...

SendKeys "%(TDC)", False

Remember that anytime you compact & repair, Access closes all objects and goes back to startup so you can't successfully do this in the middle of an application.

 

[SQL_Hell]

You can also select compact on close in the startup options, that way the database is compacted and repaired everytime you shut it down.