>I have just finished writing my first multi-user app. I'm unsure how to handle the location of the files. Obviously, I want the dbf files on the server. Should each workstation run it's own copy of the exe? Where should the path statement be placed?
>Obviously, I don't do this for a living. Thanks for any advice.
I create a SETUP.EXE installation file using the InstallShield that comes with VFP7 [I have since upgraded to the full IS Express]. I then install the program files on each PC and do not run it from the server. The data files are all on the server. I have code in my main PRG file to locate the database by looking for it along a prescribed path. The code loops through the available server drives to see if this path and DBC are found. If not, the user gets a form to identify where the databse is. There is a button that calls GETFILE() so the user can graphically locate the DBC. I then use JUSTPATH() to return just the path to the DBC to the value of the TEXTBOX on the form. Once they find the right database, I store the location to the DBC in an APPUSER table in the app installation folder on the PC.
Mark McCasland
Midlothian, TX USA