>I have a well used task processor that a client has asked me to convert to a Win Service.
>
>I have found many references to that here and it seams straight forward.
>
>But, if I am running as a service, is it not true that the service is running before anyone has logged in to the machine. Now if I need to access tables on another server on the LAN, how do I go about logging in and/or mapping to those tables ?
A service runs logged into an account, often a LocalSystem account, but you can specify any account you want. You can create a logon script that runs batch commands to map drives etc.
Another option that lets you avoid drive mapping entirely is to use, in your Fox code, UNC names for network resources. Suppose for example you have a server "DataServer" with a share "DataFolder", and you have a table "MyTable" in that share:
USE F:\MyTable ...
USE \\DataServer\DataFolder\MyTable ...
USE \\192.168.0.5\DataFolder\MyTable ...
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up