MannyRSilva

Hi Victor. I'm right in the middle of something now- just saw your post. Rather than explaining in detail here, I can send you an example of how I do a login system with our databases. It works very well. It involves creating a master login, one record file with a few globals; and another one, or perhaps two user files, depending on how you prefer to set it up. Then the privileges for each specific database are set in the user file. Creating a relationship from the master login to the user file (master::USERPASSWORD = user::USERPASSWORD) then enables user access privileges for each user. Let me know if you are interested, and I can send them to you fully open and you can check the scripting of the system. Manny Silva Child and Family Services New Bedford, MA MannyRSilva@hotmail.com

FYI for you all if you run into the same problem: We tracked the problem to a "rogue" computer that had the same TCP address as the server. My NT guy had forgotten to reserve that address for the Mac server, and after a while, someone got the same DHCP address assigned to them, causing a conflict with the Mac Server. (This again only was booting out the PCs.)

Server version is 3.0v4. OS on the G4 is 8.6. Interestingly enough, another G4 is the server for the HR Database, but no PC user has lost a connection to the files on this server. It is running OS 9.04. However, I am starting to wonder if there is a problem specific to the G4 that is cuttin goff the PC users.

Version: FM 4.1v3 This has happened once before- and restarting the server solved the problem- What happened again is that all PC users would lose their connection to the database, and then were not able to see files listed under Hosts after restarting the PC. Brief description of setup: Main Site 1 is connected to remote Site 2 thru a T1 line.

Problem: A user with a PC running WIN 2000, 128MB RAM logs into the network at startup, then launches FM Pro ver 4.1v3. She opens the main database and enters the password, but she then gets a message saying "FileMaker Pro has generated an error message and will shutdown". Here's the curious part: I can log in to the PC network with our administrator password, and FileMaker will run fine! Any thoughts before we either re-install FM, or WIN2k, or both???

You'd be surprised to see very good performance just by finding a used PowerMac 6100 with a decent amount of RAM, and using that as the Server for your small office. You don't necessarily always needs the biggest, baddest server machine around! Try it.

If you simply need to automate the manual re-entry of the ID's into each of the records again, I suggest using a script that uses the Loop function. If you are not familiar with the using the Loop function in a script, I have done it many times, and would be glad to list the steps to you later (I'm leaving from work now to go home). If you've never done it before, also make a backup copy of the database and run the script on the copy first, because an incorrectly written Loop script can hang up the file if you don't give it an "exit strategy".

I am testing FileMaker 5.0 before installing a system wide upgrade. I thought that an underscore on a file name will hide it from the Hosts listing when accessing over the network, but it does not seem to be happening, as it does when using version 4.1v3 client. Am I missing something, or is there a new way of doing this?

Thanks for the tip. I missed that option somehow.

Why not instead of a text field, create a number field for each answer? Maybe the text field is not being summarized for some reason. I did a survey file the way you did it, except the answer field was a number field equal to 1 if it was checked. Then I summarized each of the fields.