Hi Todd,

Have you looked at the ISEXCLUSIVE() function? It might be what you are looking for.

HTH,

Brian

>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