7 Replies Latest reply on Jun 7, 2012 12:32 PM by GordonShewach

    Need assistance giving end users access to the DB

    dscott23

      Developed a FMP12 solution. We are running FMP12 server. I'm struggeling with the how to of giving access to the DB to my users..some of whom are in the same ioffice with the server , while others are remote in different states.

        • 1. Re: Need assistance giving end users access to the DB
          GordonShewach

          For users in the same office, go to one computer, open a browser, and enter as the URL:

           

          fmp://IPAddressOfFileMakerServer/Filename (replace any spaces in filename with +)

           

          Drag the icon left of the URL to the desktop and distribute this as the "opener" file. May want to rename it and change its icon to a FileMaker icon first. If dragging the icon to the desktop doesn't work, try a different browser (some don't support this).

           

          For remote users assuming your server is on a private IP subnet, first you have to port forward port 5003 TCP through your router/firewall to go to the IP address of your FM Server. Then you have to determine the WAN IP Address of your office (go to IPChicken.com). The instructions above to create an opener file will work as well, but you need to use the WAN IP Address instead of the Private IP address of the FM Server.

           

          If the office WAN IP address is not static, you'll need to either buy a static IP address from your internet provider or use dynamic DNS (there are lots of good free ones; I use no-ip.com).

           

          By the way, this all assumes a static IP address for your FMS box. If it isn't static, make it so.

           

          Gordon Shewach

          Desktop Services

          Ann Arbor, MI

          • 2. Re: Need assistance giving end users access to the DB
            PSI

            Hi Scott?,

             

            Each user will need a copy of FM 12. Those in the local network should be able to use Open Remote, under the file menu, to access the served files. You should see the Server listed under hosts. if it doesn't appear you need to manually enter the IP address of the computer hosting FMS.

            Capture.PNG

            It's a bit more complicated for remote users. You can open the ports for FMS on your firewall and map them to the IP address of the server. Then the remote users will specify the WAN IP address. If you go this route make sure they system requires a login to access.The most secure method is to setup a VPN connection for each of the remote uses. this can be done with a software VPN.

             

            Hope this helps..

             

            John Morina

            Pueblo Systems, Inc.

            • 3. Re: Need assistance giving end users access to the DB
              dscott23

              Thanks so much for your answer.  My IT guy has just asked to to inquire about access via terminal services?

              • 4. Re: Need assistance giving end users access to the DB
                GordonShewach

                It works great on Terminal Services. You need to have 1 copy of FMP installed and sufficient volume licenses for the maximum number of users on Terminal Services. I have a Terminal Services server set to open the FileMaker db as soon as a user connects to the Terminal Server so they're not monkeying with other stuff that they don't need.

                 

                Gordon Shewach

                • 5. Re: Need assistance giving end users access to the DB
                  taylorsharpe

                  Using Remote Desktop Services (previously known as Terminal Services) works fine if that is what you need.  Most IT guys jump right to this because they have set up a corporate VPN for security purposes and they are unfamiliar with FileMaker's built in security.  If there are other software and a reasons to use Terminal Services such as a corporate VPN, then yes, FileMaker works fine with it.  However, if FileMaker is the only reason you are considering Terminal Services, keep in mind that FileMaker Server handles a rather robust security (SSL with AES 256 bit key) without the need for Terminal Services. Also, you get to keep the application local which has some advantages.  If you are only doing this for FileMaker, then I would stay away from it. If you have set up Terminal Services already for an enterprise VPN and have other apps you need to regularly use on it, then integrating FileMaker into it works great too. It really depends on what your setup is and why you would want to use Terminal Services. 

                  • 6. Re: Need assistance giving end users access to the DB
                    taylorsharpe

                    Gordon, you're way of doing this is not the "normal" way most FileMaker users open databases.  But I have to educate a bunch of less than stellar computer users and using a shortcut the way you described is by far the easiest for an end user and I use this method a lot.  Thanks for taking the time to spell out the details.  Please note if you are in previous versions of FileMaker, the URL begins fmp7:// and with FileMaker 12, it has changed to fmp:// which is easier.  For example:  fmp://192.168.1.3/File+Name  or  fmp://serverdomain.com/MyDatabase   Another note of caution is that not all browser support dragging the URL icon, but I do it in Safari most often and it works great.  And to make it look more professional, I add some company logo or appropriate database icon to the short cut. 

                    • 7. Re: Need assistance giving end users access to the DB
                      GordonShewach

                      The primary reason I have clients set up with Terminal Services or any remote control product (VNC, Timbuktu, RDP, etc.) is speed. While FileMaker's WAN performance continues to improve and internet bandwidth continues to widen, there is still a decided speed advantage having a computer on a LAN (the one you're remoting into) perform certain FileMaker operations vs. the same thing over the WAN from a remote site. Especially using databases with some meat on their bones.

                       

                      I believe, Taylor, this is what you were referring to when you said, "you get to keep the application local which has some advantages."

                       

                      Gordon Shewach