6 Replies Latest reply on Jan 24, 2011 11:30 AM by DanielClark

    Whats the best way to share my database?

    DanielClark

      Title

      Whats the best way to share my database?

      Post

      I am fairly new to the database world and I have been designing a database using Filemaker for about 6 weeks now. I wanted to start sharing it so the employees at my company can begin to use it. However, I am not sure the best way to do that.

      As of now, I have 1 copy of Filemaker Pro Advanced that I have been developing the database on (on my personal computer). I am planning on buying another copy of Filemaker to put on my Mac Mini server and then having that be the database location that all of my employees can access, enter and read data from.

      Before I want to buy another copy of Filemaker, I have been experimenting with my copy of advanced as to see what would be the best way to share the database in my office. I thought that Instant web publishing would be perfect - however I have been encountering many issues with that - like formatting issues (I guess when Filemaker publishes to html - images, fonts, etc get screwed up), container fields no longer contain data I want employee access to (like pdf's, zip files, etc). And scripts like "Send email" or "Print" as buttons in my layouts don't work.

      I don't want to have to buy multiple copies of Filemaker if I don't have to - I think there must be a simpler way to have my employees access to my database. I was thinking - if there is either a better way to publish the database to the web, or if I can create a stand alone runtime that interfaces (and is able to change and modify) the actual database, or something with TCP/IP or something. Again, I'm new to all this - what would be the best way to set this up?

      Thanks

        • 1. Re: Whats the best way to share my database?
          Sorbsbuster

          A lot of the differences you mention can be worked around (or should work seamlessly anyway).  How many work-stations need to access the file (as opposed to the number of employees)?  With the feature-rich tools of Filemaker and the develpment path you will doubtless go along, I wouldn't be too quick about discounting the idea of spending some money on FM Clients.  Doubtless your time isn't cheap, and denying your staff key features isn't costless, either.

          You could consider a few copies of FM Client for some workstations and employees, and some (even managers, actually) who only need to see or amend limited data or who use a limited range of functions, could use web access.

          • 2. Re: Whats the best way to share my database?
            DanielClark

            Well can I just create multiple runtime apps that all look at one database (one .fp7 file) located on a server? For example, I can develop the database on the server using a copy of filemaker advanced, and then distribute the runtimes to my employees. This way, they can access one database file through each of their runtimes.

            If not, what's the point of making runtimes if each runtime has a built in database that only one user can interact with and use at a time? Databases are supposed to be shared between multiple users afterall. If I wanted a one-user only personal database, why not just get Bento and save hundreds of bucks?

            • 3. Re: Whats the best way to share my database?
              davidanders

              Filemaker is in business to make money.  Most multiuser database programs require a copy purchased for each user.

              Filemaker runtimes do not have networking capabilities, they are one user applications.  There are clunky work arounds for syncing the data on multiple copies, but the results are less than optimal.  Syncing two copies is doable, syncing multiple copies becomes exponentially more complex.  The same sync workaround COULD be done with Bento, but the cost benefit of saving dollars on software compared to more complex developement expense has to be compared.

              IWP is limited and the limitations have to be allowed for, the web server in Filemaker and it's translation of the database to javascript is finicky partially due to javascript's limitations.

              CWP (Custom Web Publishing) is another option and information about it can be found at http://fmwebschool.com

              Without two copies of Filemaker, so you can evaluate the ease of use vs software cost is hard to visualize. Download a 30 day demo to two or three computers and test the ease of db sharing?

              • 4. Re: Whats the best way to share my database?
                DanielClark

                Could I user FM Server to share off one database to multiple runtimes on different machines? So not using a single runtime and networking that, but using one database and having multiple runtimes access that? Because I understand FM needs money, as we all do, but having multiple copies of FM all over the place just to view and edit one database file seems like using a bazooka when all you need is a pellet gun...

                • 5. Re: Whats the best way to share my database?
                  Sorbsbuster

                  "Could I user FM Server to share off one database to multiple runtimes on  different machines?"

                  David's answer is still valid: "Filemaker runtimes do not have networking capabilities, they are one  user applications"

                  ---

                  "What's the point of making runtimes"  For example: to run a fully-functioning single point-of-access database.  To let people try fully-functioning databases before buying Filemaker Clients and then going instantly multi-user.  To run a database that only uses reasonably-static info on as many work-stations as you want, at no cost.

                  ---

                  How many work-stations (not users) do you need to have shared access to your database?  If the answer is 'only a few', then you're right: you only need a pellet-gun.  That's cheap: just buy a couple of FM licenses, then, and you're away, with no-holds-barred.  If the answer is 'dozens' then I have to wonder if you don't need a bazooka after all - sounds to me like your business would be dependent upon the DB.  In which case: it's worth the investment.  If only a few workstations need all of the high-end features, buy Clients for them, and let the lower-end users log on via IWP.

                  (And If I sound like an FM Sales Guy; I'm not.  But I still think I have a valid point.  But yes, I will take any commission going.)

                  • 6. Re: Whats the best way to share my database?
                    DanielClark

                    Ok gotchya, thanks for the help anyway.