Microsoft Access MDB

[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?

[morganlefay]

Yes...you will have to use an append query.

What version of access are we talking about??

MLF

[nihil]

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?

[alakhiyar]

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.