Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL
- Thread starter Atlas
- Start date
As far as I know you have to be the Admin. or be the owner of the object or have Admin. priveledges to be able to share the directory that a file is in. I would try using Explorer to drill down to the directory, right click, select sharing, set up a share and add the permissions.
The message "File access denied" is also displayed if the file is in use by another user. Based on what you are trying to accomplish, this may very well be the case.<br>
<br>
The root cause in this scenario is that the file is opened exclusively. There are several ways to "fix" this; any of these will work:<br>
<br>
* put EXCLUSIVE=OFF in your CONFIG.FPW<br>
* in Tools/Options/Data, uncheck the Exclusive checkbox and save as default<br>
* issue the command SET EXCLUSIVE OFF in the Command Window, or within your program<br>
* when opening files via the USE command, use the SHARED clause (this generally won't help you with SQL Select commands, however).<br>
------------<br>
Raza<br>
<br>
The root cause in this scenario is that the file is opened exclusively. There are several ways to "fix" this; any of these will work:<br>
<br>
* put EXCLUSIVE=OFF in your CONFIG.FPW<br>
* in Tools/Options/Data, uncheck the Exclusive checkbox and save as default<br>
* issue the command SET EXCLUSIVE OFF in the Command Window, or within your program<br>
* when opening files via the USE command, use the SHARED clause (this generally won't help you with SQL Select commands, however).<br>
------------<br>
Raza<br>
- Status
Similar threads
- Locked
- Question