Hi Ron,
>> I was going to use the SETPATH() once each user logs in and I know their specific folder. e.g. SeTPATH('C:\User1') or SetPath('C:\User2'). In this way, they will only see their data. I know that the NT training book uses Variable file names but I would like to use the Setpath() to get to each data set.
You absolutely cannot use SETPATH to do this. The "current directory" is a non-threaded environment variable. Since multiple users can be logged in at the same time, Environment variables cannot be used at the user level.
>> I know that the NT training book uses Variable file names
you'll be shocked to know, there's a reason for that.
>> Questions: 1. Is using SetPath() a valid approach to do this?
nope.
>> 2. If User1 is in C:\User1 directory and UPLOADS a file to the server. Where will it go?
\web\uploads
(or wherever you direct it to in your code.)
>> WIll it go to .web\uploads relative to where the App EXE is running
the \web folder is already independent of the exe folder. So there's no web folder "relative" to the exe folder. That doesn't exist.
it will go to the \web\uploads folder though (or to wherever you redirect it to.)
>> or will User 1 have an UpLoads directory in C:\User1
no. the server will not serve to, or from, folders outside the web folder. The _database_ files may of course be anywhere (since their location is determined by the file driver, not the WebServer class). They are unrelated to the\web folder, and putting database files int eh \web\ folder would be very bad.
>> I have the option of making USER 1 and USER 2 folders beneath the web folder so I am not all over the disk - is that preferable?
For uploads, sure. For database files, not that would be very bad.
Cheers
Bruce