Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Location
    Bulgaria
    Posts
    1

    Unanswered: Database archiving

    Hello!
    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!
    Last edited by stanst; 10-28-08 at 19:43.

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Why not use SQL?

    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.

    Ref
    1. Access SQL: Fundamental
    2. Access SQL: Intermediate
    3. Access SQL: Advanced
    (Select Into and subqueries are in the intermediate tutorial.
    Lou
    使大吃一惊
    "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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •