3 Replies Latest reply on Oct 17, 2011 3:31 PM by philmodjunk

    Sharing help

    RachelSimpson

      Title

      Sharing help

      Post

      I am supposed to be setting up a database for our church youth group that I design and can be acessed by a few other leaders in other states (not networked together). 

      I called FileMaker customer service and asked about internet sharing and the person assured me that we could set up one computer as the server and the other people could access it and do everything they needed to do. So we went ahead and did that, bought a computer, got the internet connection set up, etc after many hiccups I have come to realize that I as the database designer do not have designer kind of functionality remotely. (sure it would have been ideal to have the server where I am, but that was not possible.)

      I called FileMaker again and this guy said if I had a copy of filemaker I could have full access to the database. But it looks like we have to be on the same network to do that, and we're not. 

      Does anyone know of another way for us to have one database that I can create and manage, while a few others can log on and do entry type work?

      Like I said it has taken a few weeks to get us to this point and now we have less than 3 weeks before our first event that is supposed to be supported by this database.

      We're running out of time and I don't know what to do. HELP!

        • 1. Re: Sharing help
          philmodjunk

          Exactly what have you set up? how are you hosting the database and how are you connecting to it?

          You should be able to remotely access the DB to do design work on it, but it will be better all around to take a copy down of the server, develop with it and then send the updated design back to the server for your fellow users to test.

          If you use a data separation model, you can reduce the need to import data from the current copy into a new copy you are about to put up on the server. With a data separation model, you split your database into two files. One file holds the data tables and the other file contains the scripts, layouts, value lists, etc needed for the interface. This enables you to replace the interface file with new copies and not need to import any data in the process.

          Convert to Seperation Model

          • 2. Re: Sharing help
            RachelSimpson

            We set up a computer to just act as our filemaker server that has a dedicated internet connection. I am connecting through the internet via the IWP, which I thought was going to give me the access to create whatever I needed to create. 

            I am not a designer, just a person with database use experience and what appears to be a pretty good manual. If there is another way to get into the creation side I would love to know what it is, otherwise, other measures will need to be taken. 

            • 3. Re: Sharing help
              philmodjunk

              If you are not the designer, who is?

              Filemaker isn't a ready made application, it's a tool for building that application. You should use Filemaker Pro to develop that solution, which means you or whoever will design the database should install FileMaker on a computer to which you (or whoever will design the database), have full access. After you have developed and tested the database on it, you can move a  copy of the database file to the server machine where it can be opened and hosted to the web via IWP.

              IWP has a number of limitations. Whoever will design your database will need to read up on the supplied documentation on web publishing if they have never done this before.