Access & Transactions

From: D Whaley (dwhaley_at_hs-technologies.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 15:18:45 -0600

When I try to Rollback a transaction using Access & ADO, the underlying data
is correct, but what I see on the screen is not, and results in the old
"Cannot locate..." errors if you try to change anything..
How do I get this to work properly automatically. Calling Requery will not
work because it causes all tables to go to the first record. If there are a
lot of datasets involved, you don't have an easy way of knowing which tables
need requerying anyway.

This does not happen using OLEDB, so I assume it is an ACCESS thing.