Hi Liam.
All the data on the worksations will be on local PC, and I was really wondering if there was some way to address each of the pc's local hard disks, but not to have to rely on Drive Mappings..maybe do it by IP address or some other way .

Gerard



>Hi Gerard,
>
>I imagine that the server will have a table of workstations to be polled and that each workstation will have a shared folder by which the files can be accessed? If this is the case you could store the path to the file for each station in the table.
>
>The pseudocode would then be
>

Select ListOfStations
>Scan All
>  if file(ListOfStations.PathAndFile)
>    Do AppendStuff
>  endif
>EndScan

>
>Regards,
>
>Liam
>
>>Hi.
>>Is there a way of Polling files on individual Workstations (connected in a LAN) to be polled from a server.
>>
>>At the end of each day, I need to Poll all the workstations caonnected (acting as Point of Sale Units) and append data into a Master table
>>
>>I know I can do thsi from each workstation, but I need more control so it would be preferable if it can be done from the server. The idea is that there would be a log of all alid connected workstations and code would be as follows:
>>
>>
>>Use Master
>>For i=1 to NumbeOfConnectedWorkstations
>> Select Master
>> Appe from WorkstatioonSlaveFile
>> Delete all records from WorkstationSlaveFile
>>EndFor
>>
>>Regards,
>>
>>Gerard