Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unusual 1705 Error
Message
From
01/05/2001 16:04:42
 
 
To
01/05/2001 15:27:05
David Brunelle
Université de Sherbrooke
Sherbrooke, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00501780
Message ID:
00502221
Views:
18
I should add that this table is a free table. Is there ever a case that a database is opened exclusively by another exe and you're opening a free table exclusively in that same directory that would cause this error?

>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
Previous
Reply
Map
View

Click here to load this message in the networking platform