Skip links

FileMaker hosting: Working with FileMaker on the go.

FileMaker training, courses, coaching

filemaker_hosting_article_imageMore flexible working hours and a different lifestyle mean that people are now working from different locations more often. Smaller companies are therefore also increasingly faced with the task of being able to access data while on the move. It is precisely for this task that a Database on a FileMaker basis: Thanks to FileMaker Go you can easily access a FileMaker database from anywhere, even with an iPhone or iPad. FileMaker even offers various ways to work together with FileMaker databases from different locations. This article on goFileMaker explains how this works in detail and what steps need to be taken to share databases.

Remote access to FileMaker databases

Suppose you run a family business with just a few employees, e.g. a wine shop. For years you have been carrying out numerous business tasks such as Orders, invoices etc. with the help of slightly modified FileMaker Pro Starter solutions. Your problem: If, for example, you are on the road visiting French winegrowers, your files are located at your German place of business. But you want to see these files and be able to edit them immediately. What can you do? The magic word is remote access (remote access). Which option is right for you depends on your goals and the structure of your company.

Peer-to-peer sharing of FileMaker databases

Let's look at the simplest solution first. Let's say your company has about ten devices (computers, iPods/iPads), some of which already have a FileMaker Pro client on them, and you don't want to buy any more FileMaker licenses right now. For this situation FileMaker offers a Peer-to-peer-sharing solution for small groups: With just a few steps, you can share your database in your local Network (LAN) and allow access for up to nine additional FileMaker or FileMaker Go clients. As a "reserve", a further five access options remain with the help of Instant Web Publishing (IWP - more on this below) and a web browser. The strength of this variant: it does not incur any additional costs, regardless of whether you are on the move with an iPad or laptop. Problem: the computer on which the database is located - experts also refer to this as the "hosting" computer - must always be running - which may be undesirable if this is the accounting computer, for example. And you need additional software such as Remote Desktop or VPN for remote access to your local network.

The ideal way: Sharing with the FileMaker Server

FileMaker's "ideal solution" is to host the databases on a dedicated and permanently running hardware server.Server with the help of software, the FileMaker Servers (FMS). The hardware for this purpose may even be somewhat older, in many cases a used Apple Mac Mini is sufficient. This solution is suitable for anyone who can and wants to equip all computers, iPod/iPads etc. with a FileMaker client or FileMaker Go. Anyone thinking about equipping their small group solution with new clients should also consider switching to this ideal solution. The great thing is that once set up, you can work with all files regardless of whether they are on your computer or hosted remotely on a server. The only difference is that in the latter case, your employees can also work with these files at the same time. Filemaker Server also ensures regular data backups.

To be able to access the file remotely, some settings must be made to the file. To do this, go to

File > Manage > Security

to the "Extended access rights" tab and click on "Access via FileMaker network"; in the next dialog box "Edit extended access right", specify which permission set is to be extended by this access right. [Image 1]. Confirm security prompts, done. In the next step, you must tell your FileMaker client once where the server on which your files are hosted is located. To do this, go to

File > Open remote > Open remote file

and click on [Add]. In the new window, enter the (preferably static) IP address of the server and confirm the dialog [Fig. 2]. In future, you and any authorized person can open the files using the Open remotely and edit them as if they were on your own computer.

FileMaker Security: Manage extended privileges

Image 1: Sharing files for remote access requires just a few mouse clicks

FileMaker hosting: Create host favorites

Figure 2: Tell the FileMaker client where the hosted file is located

The only thing that speaks against this ideal solution is that a FileMaker client or FileMaker Go is required for each device from which access is to be gained. Since FileMaker 12, FileMaker Go for the iPhone and iPad can be obtained free of charge from the iTunes App Store.

Use of Instant Web Publishing technology

If the number of potential editors significantly exceeds the number of FileMaker clients (e.g. ten FileMaker clients with thirty editors), there is another option. Here, a technology that was actually intended for other purposes, Instant Web Publishing (IWP), is "misappropriated". IWP does a good job of publishing FileMaker data in a web browser using simple means. presentfor the Editing of data via a browser, it should be borne in mind that many FileMaker functions are not supported here. Programming specifically for processing with IWP is therefore only worthwhile for a large number of employees. Less complex cases, such as the provision of a registration or order form, can certainly be implemented comparatively cheaply. Many users access a fairly simple FileMaker functionality - this also works well with IWP.

To use IWP, you need the Advanced-version of FileMaker Server to share files for IWP, you must click "Access via Instant Web Publishing" under the extended access rights (see above). The file will then appear in your browser largely as you see it in FileMaker.

Synchronization with FileMaker Go for iOS

The frequently mentioned FileMaker Goan app that stores FileMaker files on iPod/iPad [http://www.datenunddenken.de/blog/?p=523] offers an offline option in addition to the option of working with files online - certainly interesting if you frequently travel to areas with poor web connections. To do this, you create a copy of your file on your iPod/iPad, which you can edit on the go; the next time you have the opportunity, you synchronize the copy with the original again. You must initiate this yourself or have an automatic update installed with the help of a FileMaker programmer. The app can be set up conveniently via iTunes.

License models for shared FileMaker databases

Choosing the right hosting model for you naturally also requires economic considerations. There are basically three options: You Buy the software to host it on your own hardware server - You Rent them - You leave host. Whether buying or renting makes the most sense should be discussed in detail with your trusted dealer, who will work with you to select the most cost-effective license model and also keep an eye on time-limited promotions.

Neither buying nor renting? Also good, contact Service providerwhich FileMaker hosting offer: Your files are then located on the hardware server of this service provider, which hosts them with its own FileMaker Server Advanced for a fee and takes care of everything - an interesting alternative for small companies in particular.

Interesting user stories from FileMaker customers can be found on the FileMaker blog Data & Thinking [http://www.datenunddenken.de/blog] available.

Leave a comment

Share this page:

ERP software as flexible as your company.
We will be happy to advise you.

Customizable ERP software for Mac, Windows and iOS.

You are here: FileMaker hosting: Using FileMaker databases on the go.