>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?
Have you tried FLUSH ahead of your USE ... EXCLUSIVE?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up