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