Nice to have a quick snappy program when the database is small, but when it gets big... I have to export and delete orders...
We've always tried to keep at least 1 years worth of orders, but it's no longer possible as the program gets very sluggish, we only keep about 8 months worth and I'm lookin to into just keeping 6 months - we often have customers ask for copy invoices months after the order so it's nice that we can just print a copy instantly, or see a customer's past order history (sometimes a customer would call and ask for a repeat order...).
If we start using ebay extension then the number of orders more than double for us, making the mdb even bigger...
It would be nice to have exported orders moved to a second mdb where the data is not pre-loaded on startup. Old orders can be looked up, via in "Quick Find", just like the "Include PSP Pending" tick box, have a eg. "Include Exported Orders", or have a new tab called "Exported Orders" or something similar...
We've always tried to keep at least 1 years worth of orders, but it's no longer possible as the program gets very sluggish, we only keep about 8 months worth and I'm lookin to into just keeping 6 months - we often have customers ask for copy invoices months after the order so it's nice that we can just print a copy instantly, or see a customer's past order history (sometimes a customer would call and ask for a repeat order...).
If we start using ebay extension then the number of orders more than double for us, making the mdb even bigger...
It would be nice to have exported orders moved to a second mdb where the data is not pre-loaded on startup. Old orders can be looked up, via in "Quick Find", just like the "Include PSP Pending" tick box, have a eg. "Include Exported Orders", or have a new tab called "Exported Orders" or something similar...