Re: File access is denied

Are you running FoxWeb as a service? If yes, then this is most probably a file access problem. The following excerpt from the "Operating the FoxWeb Server" topic in the FoxWewb documentation deals with this issue:

Accessing remote resources
By default the FoxWeb service runs under the SYSTEM account, which does not have rights to remote resources, such as network shares. If your scripts utilize remote resources then you should change the user under which the FoxWeb service runs, by modifying the appropriate fields in the Startup options page of the Services applet in the Control Panel. Be careful not to enable the "Interact with the desktop" option, as this will cause problems with the system.

System services do not have access to drive mappings. In order for the FoxWeb service to access remote shares, you need to reference them using Universal Naming Convention (UNC). The UNC syntax is \\ServerName\Volume\PathToFile. For example, instead of "USE F:\data\customer.dbf" you would use "USE \\MyServer\DataVolume\data\customer.dbf".

FoxWeb Support Team
support@foxweb.com email

Sent by Harriet on 09/03/2002 05:21:23 AM:

Hello,

I would like to open a table which is located in other server.

In VFP 7, I can open the table.

use \\server2\data\test.dbf share

But, in mytest.fwx the error "File access is denied" is occurred.

'mytest.fwx' is in the 'server1', the table is in the 'server2'.

Both of them are webservers.

Thanks.