I'm having a problem using the BeginTrans method on an ODBC datasource.

I start the transaction using gdbDatabase.BeginTrans and obviously end the
transaction with gdbDatabase.CommitTrans or gdbDatabase.Rollback.

It works fine but before the Commit or rollback, I need to read from another
database (Access).  I get an error when trying to read from this database while
in a transaction, and subsequently cannot get to the commit or rollback because
of the error.  I suspect that VB4's workspaces will solve this problem but I am
having a hard time understanding how to implement them.

Should I be creating a workspace for the transaction methods (ODBC datasource)
and a separate one for reading the Access tables?

Need help on this one fast.  Anybody?