Tom,
I'd recommend a "server install" of the exe/dlls since it is easier to update to a new version than it would be to update 20 individual machines. Yes, there will be some network penalty whenever the program is started, but only then. Be sure to place the scratch files on the local drives. Scratch files are used for sorts, temp tables, etc. You should have no conflicts, even if they were all stored on the network drive, but storing them locally reduces network traffic and speeds the app. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Frederick Sent: Wednesday, July 16, 2008 11:06 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Multi user R:Base on a LAN We are moving our internal database project from our single user development machine out to 20 machines and eventually to users not directly connected to our LAN. Using Turbo8 compiler because of several other projects that have been requested. LAN is a mixture of speedy machines and some dogs that will need to be replaced at some point. Server works very well. We expect numerous problems based on the "didn't know I did not know that" paradigm. Our system works great on a single computer and has required "some" changes as we start moving to multiple machines. More will be coming. The differences between single user vs. multi user becomes very obvious once it does not work (particularly in demos) and you have to figure it out. Just part of the learning process. Our question (which may seem very basic): Is there a best way to set up multi-user R:Base on a LAN system? Data is on Drive Y where we can secure direct access from inquiring mice. Is it best for the EXE/DLLs to also be on Drive Y or remain on individual machine's Drive C to access the Drive Y database. We have tried both ways and they work. The concern is LAN speed (particularly for some older computers) and conflicts between tables/temps/views that the software uses. It seemed having one network based EXE that multiple people can access would really effect our LAN speed/memory, while separate EXE/DLLs on desktops isolate some memory processes and be primarily limited to moving data. I have no doubt we have a lot to learn about data and logic conflicts as we go through this. I remain amazed at just how much DYI groups like us can do with R:Base with some time, interest, and willingness to learn. Tom Frederick Elm City Center 1314 W Walnut Jacksonville, IL 62650 Off - 217-245-9504 Fax - 217-245-2350 Email - [EMAIL PROTECTED] Web - www.elmcity.org
