Within my application I collect large amount of data. Periodically, to 

reduce the size of the active mdb I am considering moving certain records 

from the active mdb to an inactive one.



However, I will frequently (once a month, generally) wish to combine the 

data from both mdbs to create trend data, i.e., charts and tables.



I'm asking for the most efficient way to implement this.



Thanks in advance for any help received.



Walt Morgan

I would link the tables from the current db into the archive & use UNION

queries to mash the tables together for reporting & such.  See also the IN

statement in Jet SQL, which lets you give a string containing the path to an

external mdb.



HTH,



-Roy



-----Original Message-----

From: Walter L Morgan [mailto:wmorgan@s...]

Sent: Wednesday, June 20, 2001 10:42 AM

To: Access

Subject: [access] Combining tables from multiple ACCESS mdbs





Within my application I collect large amount of data. Periodically, to 

reduce the size of the active mdb I am considering moving certain records 

from the active mdb to an inactive one.



However, I will frequently (once a month, generally) wish to combine the 

data from both mdbs to create trend data, i.e., charts and tables.



I'm asking for the most efficient way to implement this.



Thanks in advance for any help received.



Walt Morgan

Roy,



Thanks for responding. I will certainly try your suggestion.



Thanks again,



Walt