I understand that this only run once in a while... but are the tables that are used by this app used by some other applications that might be running at the same time??? (Sorry for the syntax... I'de need a better grammar teacher =)


>This is a stand alone exe and only one instance is running.
>
>>I've been having that error a lot before... The error 1705 : file access is denied usually occurs when you tried to open a table exclusivly when somebody is using the database at the same time, I don't know if this is what happened at your place...
>>If you are running your application directly on Visual FoxPro, maybe you should go everywhere the program is running and issue the command CLOSE ALL to make sure everything is closed, and then try to run the apps..
>>
>>Hope this will help
>>
>>>In this case, there is only one datasession.
>>>
>>>>is the only datasession?, because you close databases all work only in the active datasession, probably you have another datasession open in somewhere
>>>>
>>>>
>>>>>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