Unanswered: mutliple instances of the same database
i have recently started a new job and the central databse is written in access. There are multiple instances of the same database. I need to query records; instead of repeating queries in each databse is there a way to merge all the records into one and then query?
any help/advice greatly appreciated
Yes, it can be done. Performance will be absolutely horrific, but you could do it that way. The other idea is to create a database that synchronizes everything, another horrific undertaking. Yet another idea would be create a meta-data database that would pull from all of them in a batch process during off hours. If you don't have any control over these databases or how they're used, this might be your best option.
If you are the de-facto admin, I would first question why you have various instances of the same database to begin with. Could you provide a bit of detail about the business logic and requirements for your system? We're talking birdseye vew...
Let me first explain the situation, we have one database that data is currently being inputted to. However due to increase in data size and the system being poorly designed, it would cease to work. My predecessor created a new instance of the dbase by taking a snapshot each time this happened. The old instances are not being inputted to.
I have basically inherited a mess and my job is to collate stats untill i oversee the implementation of a new system designed in SQL server which is due next few weeks.
I require stats for the whole year and this means i have to query the current and old copies of the dbase. I am also a newbie to access so i dont know how to merge the data, is it possible to export to a spreadsheet for each instance and then create a new snapshot and then import from each spreadsheet?
It would behoove you to put all of your archival data in the same database. I would avoid querying multiple static databases like the plague. Put it all in one spot, it doesn't have to be your "live" database so to speak, but put all the archival stuff together.