I am attempting to programatically import up to 8 different tables from one access database into another. The tables include lookup, "types" tables with established relationships to the other tables. I am importing the types tables before the other tables so that they will be onfile. However, I want to wrap the entire import in a transaction, so if something goes wrong, then there won't be any orphaned data on the systeem. I'm using ADODB connections and commands and have tried all the variou isolation levels, including adXactReadUncommitted. However, I consistantly receive the following error:
"Error # - 2147467259: You cannot add or change a record because a related record is required in table..."
However, I add the related records from the related table first, without error, but they are not visible when adding the dependent records. I though read uncommited would make the uncommited records from the same transaction available to subsequent records in the transaction. Is this a shortcoming of access? Should I attempt to use DAO instead of ADO?