Hi Liam.
That's along the lines I was thinking..thanks again for your assistance.

Regards,

Gerard



>Hi Gerard,
>
>If you want to access files on another machine the target machine needs to have a share set up. To access files in this folder you can either use UNC eg, \\workstation1\sharedfolder\somefile.dbf or the IP address of the PC, eg \\192.168.123.123\shardfolder\somefile.dbf.
>
>In either case, you will need a list of the workstations that are available. You can achieve this by either keeping a list of all workstations on the network and testing for their presence during each run or you can have each workstation announce its presence (and maybe departure) on the network.
>
>If you don't want to use a file based system you might want to consider setting up a COM server on each workstation.
>
>Or maybe you'd consider a COM server on the "server" PC to which each workstation would connect and upload its data. This, to me, would seem to be the most scalable solution.
>
>Regards,
>
>Liam
>
>
>
>You can certainly use IP Addresses instead of drive mappings if you prefer.
>
>>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