p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Combining tables from multiple ACCESS mdbs


Message #1 by "Walter L Morgan" <wmorgan@s...> on Wed, 20 Jun 2001 17:42:00
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
Message #2 by "Pardee, Roy E" <roy.e.pardee@l...> on Wed, 20 Jun 2001 10:10:17 -0700
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



Message #3 by Walt Morgan <wmorgan@s...> on Wed, 20 Jun 2001 12:33:57 -0500
Roy,



Thanks for responding. I will certainly try your suggestion.



Thanks again,



Walt




  Return to Index