How can I prevent an entire table from being locked in a DAO transaction?
if a record in the transaction is added to the table, the whole table is locked
For example, a dlookup on the same table is not possible before the transaction is committed
I also tried ADO, but the same problem there too