1 Reply Latest reply on Sep 28, 2010 1:35 PM by philmodjunk

    product/licensing question (I think)

    sarat.

      Title

      product/licensing question (I think)

      Post

      I have 1 user who will be creating FMpro databases (ie, creating tables, forms, reports) and doing most of the data entry. She is in location A.

      I have 5 other users at location B who will need to see this data and one of them would ideally be able to do data entry/editing. 

      These two locations have a VPN connection (which is slow). My questions are:

      1. what licensing would I need if we used the VPN for location B people to access the databases over the network? Is this a bad idea if the connection is slow?

      2. what licensing/products would I need to have the location A person publish the databases to our webserver (hosted at location B but accessible to location A via ftp or ssh)?  And how would that work when the data online is updated? Does it keep a connection so her current database is updated?

      I'd be very grateful for any advice on the best way to design this.  thank you!

      S.

        • 1. Re: product/licensing question (I think)
          philmodjunk

          Option 1, purchase a separate copy or seat license of FileMaker Pro for each user. Since each user has a different install code you can host the file with FileMaker ( up to 9 simultaneous users ) or FileMaker Server (Many more users and much enhanced tools for managing a shared database.) and each user can connect using the Open Remote... option. I don't think VPN is necessary for this type of connection.

          Option 2, Use Instant Web Publishing to host the file to the internet or intranet. Users (up to 5 at once when FileMaker Pro is used to publish to the web, many more can connect if you use FileMaker Server Advanced to publish it.) can connect to the database via their web browsers. This option is more technically challenging to set up and places limits on how you design your layouts and scripts in order for them to work correctly within the limits of the web browsers, but saves you the cost of purchasing a copy or seat license of Filemaker Pro for every user. VPN is not needed for this option either.