Found the problem after about 2.5 hours of work. It turned out to be Norton Virus program running on the Web Server. For some reason Norton would get in the way of a COPY STRUCTURE command. VFP would never error off, but the files created on the network (Novell) were just filename.dbf and filename.cdx and both were empty. We turned off Norton's scanning of all file extensions and went back to the default program files only. Once we did this then the COPY STRUCTURE worked just fine for the web applications. So I am placing this here as a future warning or education for others who may have this problem in the future.


>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.