We have been receiving this 1705 error when trying to open a table exclusively and we're trying to track down the problem. This error is not consistent. It occurs once every two weeks.

We are running an exe that does some heavy data processing. Below is an example of the code.

... Heavy data processing ...

Sys(1104)

Close Databases All

If Used( < table > ) 
    Use In < table >
EndIf

Use < table > In 0 Exclusive

This last generates a 1705 error.

File access is denied (Error 1705)
You have attempted to write to a file that is write protected.

We are guessing that after the heavy processing the files have not closed properly, which is why we are getting that error. But why a 1705? Why not a "File is in use." error?

TIA