>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
Are you using any LOCK hints? If you add NOLOCK to your query, would it work?
If it's not broken, fix it until it is.
My Blog