Fresh MDB file for new month/Year
Posted: Sat Aug 01, 2009 2:26 am
I want to start every month with a new MDB file, but with all items and stock records transferred. First I tried to delete all orders in the POS, but that affected Inventory (sold items were put back on the shelves).
I then tried to delete all orders in the database file, and it seems to be successful. However, I wonder what other data I should delete to get a truly reset database file. InvChange is another table to clean up, would that be correct? Any other tables? Does it damage or affect anything unexpected to do this?
Eskil
I then tried to delete all orders in the database file, and it seems to be successful. However, I wonder what other data I should delete to get a truly reset database file. InvChange is another table to clean up, would that be correct? Any other tables? Does it damage or affect anything unexpected to do this?
Eskil