I have to write a visual basic application for MS Access database archiving, but I don't know which methods from which classes should i use to move records from one database to another.
Can somebody help me? I also would like to see some examples. Thanks!
Either Select Into (which creates a new table, populating it with existing data, and which can work across databases by using the IN keyword) or an insert with subquery. Again, this can operate across database file boundries.
(Select Into and subqueries are in the intermediate tutorial.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert