It may or may not depending on what causes the problem.

>One more question: When compiled and run the update statement returns "file access is denied" referring to the file name defined in lcArrivalFilePath variable. How can I handled this situation to update this table when it is already in use? Would including the following statement right before update help?
>
>USE (lcArrivalFilePath) SHARED
>
>Thanks again,
>Daniel