I'm looking for the best / easiest way to keep a daily mirror of a very large database. The db has 13 tables, and I need all information from all tables stored in access DB in the same format that fall under a certain where condition. Reason for this is a query to this main db can take hours. Im looking to have all records thats relevant to us in our local database by the time we get in the building in the morning ready to go, then we can query away on this db to our hearts content. Right now I'm looking at nightly dropping the old table and running new make table queries. Any suggestion / better ideas to go about this?
Also I have a very small idea on what tables have 1 to many relationships. I figure there no magical solution to this but any ideas would be appreciated.