Multiple Tables - similar data

[Sam H]

I have (2) Access DB with 6 Tables in each. The dataset I have is too large
to create just one Table or one DB. My data is broken out by months, Jan -
Jun in 1 DB and July - Dec in another. I want to query data from both and
all tables, how can I do this, with relationships, linking, etc...

 

[John W. Vinson]

I have (2) Access DB with 6 Tables in each. The dataset I have is too large
to create just one Table or one DB.

So you have over 2 GBytes of data? Tens of millions of records each month?

Just how big are these tables, and these databases?

My data is broken out by months, Jan -
Jun in 1 DB and July - Dec in another. I want to query data from both and
all tables, how can I do this, with relationships, linking, etc...

You can't, since you cannot enforce referential integrity between tables in
two different databases. A UNION query would let you string the tables
together, but would not be updateable and would probably be very slow
(especially if there are that many records).

Are you *assuming* that your dataset is too large, or do you have *concrete
demonstrated evidence* that it is too large? More details please!

 

[Arvin Meyer MVP]

Something tells me that your design is wrong. A database will easily hold
more that 1 GB of data and be usable.

In any case, there's no way to join the data the way you have designed it.
If you did have fields Jan-Jun in 1 table and Jul-Dec in another you'd have
to rebuild it so the data was Jan-Dec and put half in 1 DB and the other
half in a second DB, then link each of them in a 3rd front-end and use a
Union query to connect the data.