FileMaker tips, techniques, and news.

By Kevin Hammond  Posted on  August 31st, 2009  in  FileMaker

Networking FileMaker Pro Databases

Networking a FileMaker database is very easy to do, but if done improperly can lead to a damaged file, data loss, or even losing the entire application. I will go over the different options you can use.

There are three options for networking a FileMaker Pro database:

  1. FileMaker Server
  2. P2P Networking
  3. File Sharing (Not Recommended)

FileMaker Server Networking

In a production environment, this is the only way to network FileMaker Pro databases. FileMaker Server Networking carries four advantages over the other networking options:

  • Automated Backups
  • Preventing Data Loss / Corruption
  • Reliable Sharing
  • Scalable up to 999 users

The biggest advantage of using a FileMaker server is automated backups, helping keep your data safe from corruption or loss. Proper backup schedules can very easily be set up in the FileMaker Server console. In FileMaker Server 10, backups are even easier because they allow multiple copies to be stored in a single folder. We recommend going one step further and backing up your backups online with a service like Mozy or iBackups.

FileMaker Server is very reliable and should be installed on a dedicated machine that has an Uninterrupted Power Supply (UPS) installed and is not used by an end user. This way, you can be assured that your databases will always be available, won't experience crashes or outages, and not be exposed to possible data loss and database corruption.

FileMaker Server is scalable up to 250 or 999 users with FileMaker Server Advanced.

For information about allowing remote connections to your FileMaker Server read the DB Services' article Setting Up FileMaker Remote Connections with DynDNS

P2P (Peer to Peer) Networking

While P2P Networking has evolved greatly, it is not meant to be used in a production environment.

In FileMaker Pro 9 or greater, you can network via peer to peer (P2P) for up to 9 simultaneous users. The advantage to P2P is that you can share a database on your local network very fast. All that's required is each user must have FileMaker Pro installed and boom! You are sharing your application and records.

However, the disadvantages to P2P are there are no automated backups, file corruption can occur during computer crashes or power loss, and any time you want to connect to the database, the host must have both FileMaker Pro open and the database you wish to connect to open as well.

File Sharing (Windows or Network Attached Storage)

Don't do it. Why? Because only one person at a time can access the database. This is not the way FileMaker networking was designed to be used.

FileMaker networking uses port 5003 and does not rely on the traditional way of File Sharing. Contrary to the traditional way of file sharing, you should never share the folder where your FileMaker databases reside and never connect to the database on a shared folder. You will be limiting yourself and the power of FileMaker database sharing to only one user at a time. This is not a good solution at all.

Kevin Hammond thumbnail
Kevin Hammond

Kevin is CEO and Business Project Manager for DB Services. He also a founding member of the FileMaker Partner Council and certified in FileMaker 18, 17, 16, 15, 14, 13, 12, 11, 10, 9, and 8. Kevin is passionate about FileMaker as a custom application platform and is constantly on a mission to improve how he approaches each assignment.

FileMaker 18 Certified Developer
FileMaker 17 Certified Developer
FileMaker 16 Certified Developer
FileMaker 15 Certified Developer
FileMaker 14 Certified Developer
FileMaker 13 Certified Developer
FileMaker 12 Certified Developer
FileMaker 11 Certified Developer
"We were actually able to add more features than we thought would be possible within our budget. We always experienced a ‘can do’ attitude and DB Services was incredibly patient and easy to work with."
Courtney Hartman
Art Director
"The new FileMaker custom website interface is very user-friendly and easy to follow for our clients. In addition, it is much faster than the old Instant Web Publishing (IWP) interface. Thank you and all the others who have helped us out at DB Services. I am very grateful for the excellent service you provide us. Its nice to know we can call you for help if we have an issue."
Wayne Capek
President
"We needed a solution that would simplify the administration of our responsibilities under our contract with the State of Indiana. We have seen a dramatic increase across the state in the number of potential foster and adoptive parents that have begun the preparation and training process. This increase has resulted in a significant opportunity for children available for adoption. That’s a big win for everyone! And it’s all because we can refer potential parents to the proper state contacts efficiently and quickly."
Chris Morrison
Executive Director
"Thank you for all of your expertise and valuable help. I am so grateful to have found DB Services."
Linda Findlay
Owner
"Thank you for our new database system. We transitioned from a carbon copy paper based system to a digital database. The software has saved us time and money. We used to archive all our jobs in cabinets, now we can look up a job in seconds from anywhere. The software allows us to easily email estimates to our customers in pdf format. In a year there was a return on investment just from eliminating the purchasing of our carbon forms."
Todd Cartmel
Owner
"The new system allows us to create and track jobs for customers along with inventory, something we had been doing with separate word and spreadsheet files. Because it’s now so intuitive, new staff members are able to begin using the database immediately without our usual training session and ‘cheat sheets’ for getting around within the file."
Tom Andrews
President