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!