Querying against two seperate Access DBs

[tonydotigr]

Hello all.

I'm trying to open a connection and create an SQL statement with two different tables in different Access DBs. Is this possible? I'd like to join the tables in a query.

Is there a great advantage in splitting somewhat large Access databases? Or is it best to just create a large access database with many tables?

Thanks!

[Shaggy Hiker]

There is no advantage to splitting the database. Consider whether you would even be asking this question if you had combined the two? Perhaps, the easiest solution would be to create a View of the relevant tables from DB2 in DB1, in which case you can query against the view as if it were a table in DB1.

[tonydotigr]

I have never created a view, any good resources? Thanks for the quick response!

[Shaggy Hiker]

In Access, a view is a query, so if you have done queries, you have created views. The more difficult piece, as far as I am concerned, is accessing the other DB as a datasource. I have seen it done, but have never done it myself.