>
> I recently tried using transaction processing on a form
> with two child grids. The Rollback command made cancelling multiple actions
> easy to program. However, I found that transaction processing locks the
> file even for new record adds by another user. I contacted Microsoft and
> they confirmed this. They said that transaction processing had not been
> implemented with an eye toward individual record handling. I had thought
> that only existing records being modified, or a single append blank record,
> would be locked by transaction processing. I was wondering if anybody had
> tried using trnasaction processing and came up with a way around this.
>
> TIA
>
> Jim Boho
> Univ of Wisconsin

Jim,

I use transaction processing. I let the forms enter the information in
temporary files (clones of the db tables) and at save time I copy it all
to the db in a transaction. The advantage is that if any of the
updates against the DB fails, you rollback.

Marc