We are a gift shop with many, many new items each year and only a few reorders. Thus, we have lots of item codes that are not being used. Each year we try to clean up the items database and delete those item codes that have not been used for over 2 years and for which the Qty=0. I have just completed deleting the items no longer in use. Our database is huge. Is there a way to compact the database after deleting these items no longer in use each year? We transferred from QuickSell 2000 and there was a way to compact the database in the Doctor program.
- posted
16 years ago