Bob,
A Transaction command locks the records that are affected until the END Transaction or ROLLBACK commands are made. You should only use a Transaction command at the time you are saving data. Don't open a transaction until your user has completed editing and your program has done all the required validation. Then open the Transaction, save/update/delete data as required and complete the transaction.
HTH
Barbara
>Hi All,
>
>I am working on an application which uses a VFP 3.0 database as a backend. If I begin a transaction and perform an update on a record in a table, no other user can perform updates on that table. Is this the normal behavior?
>
>Thanks
>
>Bob