Using 2 databases

  • Thread starter Thread starter Steven
  • Start date Start date
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.
 
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.
 
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.
 
Back
Top