Hi , I'm using Access 2003,
Q. I was wondering is it possible to compact an individual table within a database?
Reason for asking, I need to bring into a Data store table circa 250K records at a time, on different products we sell
Basic procedure is:
Upload product ‘A’ in to the Data Store tbl, various procedures take place and the resulting outputs are stored in a temp table for product ‘A’.
The data held in the Data Store tbl is then deleted; the procedure is repeated for the remaining products.
My issue is the database can grow considerably in size, so I was wondering if you can compact the Data Store tbl, on each loop of the products, to keep the database size down.