3 Replies Latest reply on Jan 13, 2012 10:02 AM by philmodjunk

    data sharing question



      data sharing question


      I'm currently using a trial version of FMP, to figure out whether it'll do what I want. It'll do the job, I'm sure, on one machine. But I'm a little confused on sharing data... perhaps someone can clarify for me.

      I'd develop and maintain the program on one computer, and the actual data entry would occur primarily on another computer (just one). I believe I'm allowed two installations of the program, so that should work.There'd be perhaps three other computer users on the same network who would need some access to the data, and would make occasional entries.

      Main question: to what extend can that data be shared with others using IWP in the same network? Can other users run reports, print reports, access the data directly on IWP? Can they enter and/or change data relatively easily? With just a few users, would it be slow and cumbersome? (We're on a Microsoft 2003 Server network, but don't want or need the expense of a server version of FMP).

      Second question: do I need FMP Advanced for any reason involving sharing? I could make a runtime version with Advanced, but as I understand it, couldn't share data entered on one computer with another.

      And a heresy question... is there another database program which would do what I want more easily? (Sorry!)

        • 1. Re: data sharing question

          Filemaker Client will happily host your system (up to 9 other users.)

          You cannot have the same FM client twice on the same network.

          IWP is really good.  There are a few scripting limitations (not major, and well-documented) which do not work 'natively' in IWP, but if you know your file will be accessed by IWP you can easily accommodate those when designing the scripts.

          All the data will be available to all the users, no complex set-up required.

          You don't need Advanced to accommodate sharing; it has developer tools that will be handy for you when designing.  There is no difference from the users' viewpoint.

          There is no rapid application development database to match Filemaker.  (Well, what did you expect...?  But then you haven't actually told us what the job is that you want it to do.)

          • 2. Re: data sharing question

            One FMP serial number will allow one user to access and share the database.

            A second copy with the same serial can not access the hosted database on the other computer.
            Up to nine FMP users (unique serial numbers) can access the database shared using the built-in sharing in FMP and FMP Advanced.
            You could have three users with the same serial number and any ONE at time could access the database.

            FMP or FMP Advanced can host a database(s) via Instant Web Publishing with a limitation of 5 concurrent users. 
            FileMaker Server Advanced can host a database(s) through Instant Web Publishing for up to one hundred.

            Google "filemaker iwp limitations"

            Filemaker is the most popular cross platform easy database currently.

            • 3. Re: data sharing question

              The advantage to having FileMaker Advanced is for you as the person responsible for creating and maintaining the database. The script debugger alone can save you hours when a script does not produce the expected results and you need to track down the reason. Throw in the database design report, data viewer, the ability to add custom menus and custom functions to your solution (and which others without FileMaker Advanced can use once you have added them to the file), and you have a tool that can save you time and produce a much more professional user interface.