Cascading and Repairing the Database

[Dave31]

Hi

I have a master reset switch on my database, which erases all data in all my tables (execpt for a few important details).
I know if you then repair and cascade the database (via Tools>Database Utilities) then it will reset the auto numbers back down to zero and start again. As i know of only the button press to do this, i would like to know if theres a piece of code that does this for me on the button press?

Many Thanks

 

[boblarson]

Just for your knowledge's sake - That's COMPACT and repair not Cascade.

Second, the code you can use is:

SendKeys "%(TDC)", False