Microsoft Access MDB
Results 1 to 4 of 4

Thread: Microsoft Access MDB

  1. #1
    Senior Member Info Tech Geek's Avatar
    Join Date
    Jan 2003
    Location
    Vernon, CT
    Posts
    828

    Microsoft Access MDB

    I have an old MDB that I pulled off a backup tape, can I merge that with my current MDB that is missing the old data? If so, how would I do this?

  2. #2
    AOs Resident Troll
    Join Date
    Nov 2003
    Posts
    3,152
    Yes...you will have to use an append query.

    What version of access are we talking about??

    MLF
    How people treat you is their karma- how you react is yours-Wayne Dyer

  3. #3
    Senior Member nihil's Avatar
    Join Date
    Jul 2003
    Location
    United Kingdom: Bridlington
    Posts
    17,190
    Hi, ITG

    There are a variety of ways......... as Morgana~ says, what versions of Access are we talking? (like the old stuff and the new stuff)

    "append" woulkd be a classical approach, but depending on the situation, perhaps creating the backed up data in a new DB and running an update query might suit?


  4. #4
    Senior Member alakhiyar's Avatar
    Join Date
    Dec 2006
    Location
    Land of Oryx
    Posts
    255
    Quote Originally Posted by Info Tech Geek
    I have an old MDB that I pulled off a backup tape, can I merge that with my current MDB that is missing the old data? If so, how would I do this?

    I haven't had to do this, but you can right-click | Import in the databases window. I'd expect you can import your old tables and either have them appended automatically or just copy/paste data.

    Backup both and play around a bit.
    (\__/)
    (='.'=)
    (")_(")

Posting Permissions

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