I am stuck and I have yet to find a workable answer in all the books or reading I have done to date.
Background: VB6, Access97, ADO 2.6(or somewhere around there.. its hard to keep up with all the ado updates)

I have one access database that I want to import more records from another access database. BUT.. I also need to delete some records keeping track of what records I am deleting. I need to also update a separate table indicating if the records are new or changed, how many records of any one type are in the new database. Some of these databases can be very large 20,000 + records at a time to import (yes I know why the heck are you using access?).

I can make separate Record Sets in each database but I can’t seem to make them interact with each other. It almost seems like I would have to import the record set into the new database and then work from there even though that is going to mean more work and slow things down rather than updating the records and importing a single time.

I am not a greatly seasoned VB / ADO programmer, but I haven’t had any problems until I encountered the multiple database issues.

Any guidance or information would be appreciated.

Thanks,
-J