Fresh MDB file for new month/Year

General discussions about Abacre Restaurant Point of Sale
Post Reply
Nongkiau
Posts: 35
Joined: Sun Jul 20, 2008 4:36 am

Fresh MDB file for new month/Year

Post by Nongkiau »

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

Abacre
Site Admin
Posts: 1223
Joined: Mon Jan 31, 2005 5:32 pm

Re: Fresh MDB file for new month/Year

Post by Abacre »

Yes, you can clean up InvChange table.
What's typical size of your database file at the end of the month?
Can you send your database file (in zip archive) to support@abacre.com? So we could do some performance tests and tuning based on a large database file.
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

Post Reply