I would like to empty certain tables, and perform a compact & repair on them.
Reason being is I need empty the tables and reset the auto index values.
I am using Delphi 7.0 + ADO + MS ACCESS
What is the best method of doing this via runtime (code)?
Sample code please!
I will start this off at 100 points, but will increase it significantly for a good solution!