I am using compiler and have many users. I put the database, exe, and dlls on a share on the server. My network is gigabit and my users are 100mb(small users) or 1 gigabit users(power users). Gigabit is so cheap now days that it is worth the money vs time waiting. You can also do terminal services/citrix. Then network speed and pc speed is taken out of the equation. Just the server needs to be beefy. I do both. Dan Goldberg
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Frederick Sent: Wednesday, July 16, 2008 8: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
