Compact database

Jul 07, 2007 0 Replies

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.


Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required