Using 2 databases

S

Steven

I have a database that is approx 600MB. About 450MB could
really be stored in a second database because it is
history.

Question: If I move the 450MB to a second database how
can I UNION a query from the main database with a query in
the second database so when I open a form I can get the
entire group of records I want.

Thanks for your help.

Steven.
 
A

Albert D. Kallal

You certainly can.

That database size sounds quite large. What is the size after a compact and
repair?

Anyway...the answer is yes. You can move the data to 2nd database, and for
history/summary stuff, you can union query.
 
K

Kirk P.

I've done something similar by creating a "link" to the archived database (click New => Link Table from your Tables object). Once you have the link to your archived table, you can create a query and join the archived table to your new table.
 
Top