Have you looked at FAQ # 7896 and FAQ # 7790?

>Hi all,
>
>I am troubleshooting a problem where an INSERT-SQL is failing due to "File access is denied." I am at a loss as to how to trace the cause of the problem as it happens intermitently. The file in question has a very high access (READ/WRITE) rate. I've asked our client to moniter the table using a 3rd-party utility but the log gets so huge rather quickly and the process is manual.
>
>I am looking at putting the INSERT-SQL inside a try/catch and when the problem happens; capture the Open Files data and log it so I can hopefully find out the process that has the table locked. The Open Files that I'm talking about is the list one would see if you right-click on
>

>My Computer->Manage->System Tools->Shared Folder->Open Files
>

>using Win32 API.
>
>1. Can anyone point me to a similar solution using Win32 API? I am still looking around for the method that will allow me to get this information.
>2. Can anyone suggest another approach on how to troubleshoot/log the problem?
>3. What happened to the Win32 API section in UT?