Yes you can do this. You can either link them in a seperate Access file, or link them to each other. I would use a seperate file since naming tables will be difficult if they are linked to each other. For example:
If you have three databases, all with the same tables, let's call one "tblLedger," then when you link them in one file you will get:
tblLedger
tblLedger1
tblLedger2
You can either consolidate the data this way, or more elegantly you can do this with code that pulls all the data from all three databases into a single table. Create a table in your new database called "tblLedger" and then create the following:
A Delete query to remove all the data from the table.
A connection to the first database that pulls all the data from tblLedger in that database and adds it to your local tblLedger.
2 more connections that pull the same data from the other two databases and adds them to your local tblLedger table.
Then run your subsequent queries to create your reports.
If you were going to this trouble, however, perhaps a SQL server back end would be the way to go?
Did this help? Do you need code?
mmcdonal
|
