Re: Access & Transactions

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 02/25/04

  • Next message: Chris LeFebvre: "ADOTable.Locate Workaround?" 
    Date: Tue, 24 Feb 2004 20:55:32 -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.
    Its not appropriate to use transactions when the users are interacting with
    data. You may want to use Locktype batchOptomisic so that you can make edits to
    your Tadodataset and apply all updates as a batch or cancel your updates 

    --
Brian Bushay (TeamB)
Bbushay@NMPLS.com
  • Next message: Chris LeFebvre: "ADOTable.Locate Workaround?"