I have the following situation. I have an existing program (which I cannot change) that stores information on an Access database table (I'll call this database the "original" database). Once a day, this program backs up the received data into a "backup" database, that has a table with identical structure to the original one.
Now, I'm been asked to implement a program that lets the user see those information (i.e. both the one on the "original" table and the one on the "backup" one). This is because this information are events received from an HW device, and the user shall be able to see not only "today" events, but also the ones in past days.
How to do this?
The actual problem is that I need a way to do a "join" based on the backup table _and_ on some tables that resides on the original database. Is there any way to do this?
I would like to avoid creating a new table that is the union of both, since I've got many events, and it would take some time to do this...
Any suggestion on the best practice to do this?
Thanks in advance.