We have set up some processes that run automatically at night and once in a while someone has a table open at the time we are trying to use it and I am looking for a way to detect if the file is already being used exclusively. We can detect if the table is there but not if it is being accessed exclusively. Is there a way to do that.

Thanks
Todd