Mary Haugan Posted February 29, 2008 Share Posted February 29, 2008 I have a database that has about 20 subfiles that open up upon a script within the first file. We have a new guy coming in unexpectedly. He asked me to make a copy of the folder where all the databases are stored. I have questions. I have to add a new password for him to each of these databases. Do I really have to open each one separately to do this? Also, I would like to change all of them to single user as well. Again, do I really have to open each one separately to do this? Also, these databases are hosted on a server. After I give him the copy of the folder COULD this cause problems with my relational databases if he keeps the folder on his desktop? Thank you. Mary Quote Link to comment Share on other sites More sharing options...
AHunter3 Posted February 29, 2008 Share Posted February 29, 2008 a) Do not, I repeate DO NOT, copy the served files while they are open. FileMaker Server needs to be shut down and then copies made and offloaded to a different machine, and then FmServer restarted. b) If you are distributing to him a copy of the same files with the same file names, make absolutely certain that the FmServer box does not have OS-level file sharing on (which should be the case anyhow, file sharing corrupts hosted files); and also make sure that this person's local copy of FileMaker has networking turned off (Application Preferences: network choice). That's the only way to make even moderately certain that this person will not end up with one of the hosted files being referenced & opened by one of the local files and/or vice versa. Especially vice versa. c) If you're going to give this person a separate password, yeah, you have to add it to each and every file. And you have to do that on the copies after they are made. You're best off if you have a copy of FileMaker Developer, and can make renamed copies of the files with the developer tool. Those renamed files will not get confused with the live / served files. Why does this person need a local copy of your database, if you don't mind me asking? Quote Link to comment Share on other sites More sharing options...
Mary Haugan Posted February 29, 2008 Author Share Posted February 29, 2008 a) Thanks for the note about the server being down. I already have that one covered. b) I'll figure out the server stuff per your notes c) oh how fun d) don't have developer. Bummer. e) I'm on a research grant. He's on a different research grant. My grant is ending and there may not be funding for me in May. My boss asked him to get to know my processes and databases, etc. in case they have to let me go. He uses oracle and java and the web for his study. I just host files. Anyway, he doesn't know FMP and he figures he can "play" with the copies and learn my databases that way. I don't have a lot of written documentation. Most of it is in the database itself. And that's the scoop. Quote Link to comment Share on other sites More sharing options...
Mary Haugan Posted February 29, 2008 Author Share Posted February 29, 2008 ***make sure that this person's local copy of FileMaker has networking turned off (Application Preferences: network choice). I don't see where I can turn off the networking under Application Preferences. I'm using FMP 6 if that helps. Quote Link to comment Share on other sites More sharing options...
Mary Haugan Posted February 29, 2008 Author Share Posted February 29, 2008 make absolutely certain that the FmServer box does not have OS-level file sharing on (which should be the case anyhow, file sharing corrupts hosted files); I also don't know where to find this either. Thanks again. Mary Quote Link to comment Share on other sites More sharing options...
AHunter3 Posted February 29, 2008 Share Posted February 29, 2008 I don't see where I can turn off the networking under Application Preferences. I'm using FMP 6 if that helps. Here (see bottom of post) is a screen shot of the application preferences for FileMaker Pro 6. On a Mac you invoke it via FileMaker Pro menu, Preferences, Application. On a PC I'm pretty sure it's Edit menu, Preferences, Application. Network prefs are towards the bottom. In this screen shot they are set to "" which is the setting you want on this person's computer. ------ make absolutely certain that the FmServer box does not have OS-level file sharing on (which should be the case anyhow, file sharing corrupts hosted files); I also don't know where to find this either. Thanks again. Is your server a Windows server or a MacOS X server? (Or, since you're using server from the FileMaker 5.x/6.x vintage, I guess it could conceivably be a Linux server or a classic MacOS 8/9 server?) Windows: open Services. Find the Service simply named "Server". Disable it if its not already disabled. MacOS X (if not OSX Server): Open the Preferences Panes. Find the Sharing Pane. Turn off Personal File Sharing and Windows file sharing MacOS X Server: Find a program called Server Admin. On the lefthand side should appear your computer's name followed by ".local" (perhaps other computers will be listed, but if so ignore those). Click on it and click the disclosure triangle so it shows services. Disable the service "AFP" and the service "Windows". Linux: sorry, been way too long and used it way too seldom to recall. MacOS 8/9 (unlikely in this day & age): Open the File Sharing Control Panel. Stop file sharing if it's running Quote Link to comment Share on other sites More sharing options...
Mary Haugan Posted February 29, 2008 Author Share Posted February 29, 2008 This website won't let me open the jpg.gif file. Either way I don't see what you describe in my mac or pc versions. Could you e-mail the file to me directly? Just a thought. Mary Quote Link to comment Share on other sites More sharing options...
AHunter3 Posted March 1, 2008 Share Posted March 1, 2008 Here: Quote Link to comment Share on other sites More sharing options...
Mary Haugan Posted March 3, 2008 Author Share Posted March 3, 2008 Windows: open Services. Find the Service simply named "Server". Disable it if its not already disabled. OK. I found Services/Server and I have three choices. Stop, Pause or Restart. When I press Stop, it says that when the server stops these other services will stop. Computer Browser. Is it ok if the computer browser stops? Sorry. I don't know PC's very well and it wasn't my choice to have a pc server. Heh, heh. Thanks again for your help. Quote Link to comment Share on other sites More sharing options...
AHunter3 Posted March 3, 2008 Share Posted March 3, 2008 Yeah, anything running on top of the service "Server" can be halted also. If anyone is using your FileMaker server as a FILE SERVER it's going to disappear out from under them, to give them a heads-up. If anyone is connecting to the FileMaker databases in an illicit manner (e.g., direclty double-clicking the file via Network Neighorhood or by mounting the FmServer volume on their Mac Desktop) they'll have to learn how to do it the proper way instead. Quote Link to comment Share on other sites More sharing options...
Mary Haugan Posted March 3, 2008 Author Share Posted March 3, 2008 But it won't affect people accessing the FMP databases that are hosted, will it? Quote Link to comment Share on other sites More sharing options...
AHunter3 Posted March 3, 2008 Share Posted March 3, 2008 You mean if they are currently logged in? No, not at all. As I said, if they are getting INTO those hosted db's through inappropriate mechanisms they'll have to learn the proper ways instead from now on. Quote Link to comment Share on other sites More sharing options...
Mary Haugan Posted March 3, 2008 Author Share Posted March 3, 2008 I'm sorry. I think I get what you're saying. It won't affect the way my users normally get into their databases. I think it interesting that the server was set up with os level file sharing on. I can't imagine that was a default, but who knows. I didn't get to set it up, but I get to make any changes to the set up. I will also tell all my users they need to set their network choice to none. Thanks again. I learned something new here. I hope it helps other users. Quote Link to comment Share on other sites More sharing options...
Mary Haugan Posted March 3, 2008 Author Share Posted March 3, 2008 I didn't mean all my users. Just that one that I'm making copies for. Quote Link to comment Share on other sites More sharing options...
AHunter3 Posted March 3, 2008 Share Posted March 3, 2008 Correct! You certainly don't want your regular users' network choice set to "none" or they won't be able to get into the regular database! Quote Link to comment Share on other sites More sharing options...
Mary Haugan Posted March 3, 2008 Author Share Posted March 3, 2008 Thanks again! Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.