After a BeginTrans (with ADO 2.7 / SQL Server 7), and an operation (edit, add, or delete) on a table, any other user can even open that table until the CommitTrans or RollbackTrans.
They get a time-out error.

As the user that started the transaction, commits or rolls back, the other users can finally view the results of their pending queries.

I would like not to lock ALL the table during a transaction.
Is this possibile?

Many thanks in advance.