Dear Chistof,
I've noticed that even a select statement on one table is locking it. ie select prodcode from tuserprod somehow locks tuserprod table.
Funny thing is that even after I close the form in question, the lock still exists, how do I unlock this?
Yau