We have a web system here that has been working for quite some time. But when we got hit with a virus the Admin's decided to turn off permissions to files and shares on the server and network.

What I have is a program that does the following:

*use the UNC to alleviate the problem of drives being mapped differently
lcDataFileLocation = '\\websrv\vfpdata\acis\data\'
lcTempFileLocation = '\\websrv\vfpdata\acis\temp\'

*create a variable to hold the name of a temporary table
*sys(2015) works better since sys(3) may return a non-unique name when issued successionally on a fast computer.
lctemptable = 't' + SUBSTR(SYS(2015),2,9)

*copy the structure of pqtacis to the temporary table
*this will allow multiple users to use the system simultaneously
SELECT 0
USE lcDataFileLocation + 'pqtacis.DBF' SHARED
COPY STRUCTURE TO lcTempFileLocation + lctemptable + '.dbf' WITH CDX
USE

*open the tables needed for the select
USE lcTempFileLocation + lctemptable + '.dbf' IN 0 SHARED

When this code is executed I get the following error:

Error #: 15
   Message: Not a table.
   Program: C:\PROGRAM FILES\FOXWEB\PROGRAMS\WEBNONSMPRICING\NONSMPOMQTYS.FXP
   Line # : 18
   Line   : USE lcTempFileLocation + lctemptable + '.dbf' IN 0 SHARED

So I ran the same code locally from my machine and all worked OK. Then I ran the same code from the NT box and got the error that it was 'Not a Table'.

So my question is this what directories does VFP touch in order to to a COPY STRUCTURE... I think we have lost permission somewhere, but VFP never gives an error that the COPY STRUCTURE failed. What I get is 2 files in the temp directory (a DBF and a CDX) that are not a table.

Any help would be appreciated.