Edward-

>Do you mean 'unavailable' in as sense that multiple locks will interrupt other users working with data? I do not think that's critical, because transaction is dynamical, i.e. locks will be applied for short period of time and SET REPROCESS will take care of this. Anyway, locks will be applied to real tables, not to buffers.

I mean that using transactions on buffered tables is only useful if you do all your processing within the transaction (add, delete, edit records). Since that's the case (as I understand transactions), the tables are indeed unavailable to others.

For example, open two VFP sessions. Use a table in one, begin a transaction, and then append blank in a table. Switch to the 2nd session and use that table (notice you don't see the same record count), and append blank or delete. You'll get the message that the record is not available.

Now, consider that the person adding an invoice (for example) for a customer. They add the record and find some problem...like their coffee cup is empty...they go off to find an answer..or get more coffee :)... Meanwhile the other poor sap is stuck.

Do you see what I mean? It's dangerous, IMO, especially since implementing buffering is so painless.