This was awesome. I have added my VB solution using ADO to help identify the req_spid.

On Error GoTo errLockTable

'1. determine if the tdatWeeklyDetail table is locked.

'2. return...