Currently I have a POS system that runs of 2 access databases, one for sales and one for configurations (price, printer, vendor etc). Some of the POS applications has index errors or corrupt databases once in a while. I need some assistance with the following:
1. I want the database.mdb to create a database.mdb_temp every hour or so in a different location on the computer.
2. As the file create temp database every allotted hour, I will want the oldest database to be deleted so storage space doesn't become an issue.
Anyone can help with this?