T
Tony
Hi All,
I've got a problem that I hope can be solved by some function in Access but
am unsure as to where to start. I'm using Access 2000 and have a database
with three tables linked by autonumber primary keys. The problem is that I
inadvertently blew away some records and their related records - first table
cascades to second cascades to third. I have a good backup and all the
records, but it's been awhile since the gaffe, so I just can't restore from
the backup without overwriting new records.
I think I start by building a make-table query in the backup to combine the
three tables, import into a temp table in the production db, then split into
three related temp tables. Where I'm stuck is how to append the records
from the temp tables to the production tables while maintaining the
relationships.
Any help is much appreciated.
Thanks & Ciao,
Tony
I've got a problem that I hope can be solved by some function in Access but
am unsure as to where to start. I'm using Access 2000 and have a database
with three tables linked by autonumber primary keys. The problem is that I
inadvertently blew away some records and their related records - first table
cascades to second cascades to third. I have a good backup and all the
records, but it's been awhile since the gaffe, so I just can't restore from
the backup without overwriting new records.
I think I start by building a make-table query in the backup to combine the
three tables, import into a temp table in the production db, then split into
three related temp tables. Where I'm stuck is how to append the records
from the temp tables to the production tables while maintaining the
relationships.
Any help is much appreciated.
Thanks & Ciao,
Tony