We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Software Reviews
15,670 Reviews

FileMaker Pro 9.0

£219 inc VAT

Manufacturer: FileMaker

Our Rating: We rate this 4 out of 5

Serious FileMaker developers, database and network admins, and managers who worry about tying different piles of company data together are going to be the big beneficiaries of major improvements in the latest update to the FileMaker family of products.

Until we get six to eight months of real-world experience with FileMaker Pro 9.0, it may not be possible to assess this new feature. A FileMaker developerwho's also experienced with SQL told us that FileMaker Pro 9.0 isn't quite ready to deliver the performance of a Porsche with the gas mileage of a Prius. But wouldn't it be nice if it could?

One thing we're sure of: SQL-connectivity is going to sell a lot of copies of FileMaker Pro 9.0 to network admins and managers who sometimes stayed away from FileMaker in the past because it couldn't talk very well to the SQL database that was the heart of their company's data management system. Now it can. In fact, FileMaker Pro 9.0 can now carry on a conversation with that database almost like a native speaker.

And what if you couldn't care less about SQL? The do-it-yourself users and small workgroup users who are the majority of FileMaker's market, will be relieved to know that you still do not have to use SQL. If you turned to FileMaker in the first place because it wasn't SQL, well, it still isn't.

More (and better) connectivity

There are a couple other deep changes in FileMaker 9 that will affect a lot of FileMaker's existing users. There is a new version of FileMaker Server, the software that lets you share your FileMaker databases on a LAN or WAN. Particularly noteworthy is the fact that the installation and set-up process has been redesigned completely. A process that used to make even experienced network admins break out in an anxious sweat has been improved so much that you can pretty reliably hope to get the job done in under 20 minutes.

The Web-support provided by FileMaker Server Advanced now includes the ability to generate an entire PHP-driven website automatically from your FileMaker database. We haven't fully tested this feature yet, but it looks very promising.

Finally, while FileMaker Server and Server Advanced have become much easier to install and administer, the price has not dropped, so if you only need half a dozen users to connect to your database, you may be happy to know that the number of peer-to-peer connections allowed by FileMaker Pro 9.0 has risen from four to nine. FileMaker Server is the preferred way to go even for two or three users, but peer-to-peer sharing works, and if you're on a very tight budget, it can be a life saver.

What else is new

Finally, let's look at the surface, the improvements that you can start using the minute you install FileMaker Pro 9.0. Our favourite enhancement is the new Append to PDF command, available both in the File menu and as a script step. Save as PDF has been around since FileMaker 7.0, but the new Append command makes it possible to create a single PDF that uses several different layouts, or to append July results to a report that currently goes only through June. Not sexy, but very useful.

FileMaker Pro 9.0 also offers a number of nice enhancements for layout designers. Conditional formatting can now be applied directly to a field object on a layout. So for example you can easily highlight invalid entries or negative amounts.

It's also possible now to configure layout objects so that they resize automatically on screen. Serious script writers will be grateful that, in FileMaker Pro 9.0, it is finally possible to group related scripts together inside organisational folders. There are many other smaller changes, including a new startup screen, better online help while you work, live updating, and more.

Let's close with a bit of trivia: FileMaker Pro 9.0 is the first odd-numbered release in the product's nearly 20-year history that does not introduce a new file structure. FileMaker's press materials understandably don't put this fact right at the top of the features to get excited about in FileMaker Pro 9.0, but after the revolutionary upheaval that accompanied the release of FileMaker 7.0 a few years ago, it's reassuring to know that upgrading to FileMaker Pro 9.0 is not going to break anything.

In our testing, all our existing FileMaker 7.0, 8.0 and 8.5 databases opened up and ran in FileMaker Pro 9.0 without a single hitch. Most of the FileMaker 9-specific features even break fairly gracefully when you open a database that uses them in an older copy of FileMaker. For example, layout objects set to resize in FileMaker Pro 9.0 simply don't in FileMaker 8.5, and script groups created in FileMaker Pro 9.0 simply show up as empty folders in the ScriptMaker in FileMaker 8.5. But everything still works perfectly.

FileMaker Pro 9.0 Expert Verdict »

Windows XP Professional, Home Edition (SP 2): Pentium III 500MHz or higher
256MB of RAM
CD-ROM drive
SVGA (800 x 600) or higher resolution video adapter and display. Windows Vista Ultimate, Business, Home: 800MHz 32bit (x86) or higher
512MB of RAM
SVGA (800x600) or higher resolution video adaptor and display
CD-ROM drive. Mac OS X 10.4.8: PowerPC G3, G4, G5 or Intel-based Mac
256MB of RAM
CD-ROM drive
  • Ease of Use: We give this item 9 of 10 for ease of use
  • Features: We give this item 8 of 10 for features
  • Value for Money: We give this item 8 of 10 for value for money
  • Overall: We give this item 8 of 10 overall

FileMaker Pro 9.0 looks like an impressive upgrade. The product is moving in the direction that power users have been hoping for, and in the long run, this is going to benefit everybody who uses the application.

  • FileMaker Pro 11 review

    FileMaker Pro 11

    FileMaker Pro 11, the latest update of the venerable database software, improves on version 10 with several more features such as charting, "recurring import" to automatically update a database from an Excel or text file and a "Quick Find" search box.

  • FileMaker Pro 8.5

    FileMaker Pro 8.5

    Pro's ease of use and cross-platform nature seem to have put its rivals out of the running. A new version would need some seriously useful tools to make upgrading worthwhile.

  • FileMaker Pro 8.0 Beta

    FileMaker Pro 8.0 Beta

    FileMaker Pro, the easiest fully fledged database program PC Advisor has seen, made a great leap forward with its last release, adding relational capabilities. So what are the developers doing for an encore with FileMaker Pro 8.0?

  • FileMaker Pro 10 review

    FileMaker Pro 10

    FileMaker Pro 10's ease of use and powerful features make it the database application of choice for home-office and small-business users.

  • OpenOffice.org 2.0 Beta

    If you're thrifty and you use an office suite, it's hard not to like OpenOffice.org. Version 1.0 does most things Microsoft Office can do. And it's free. So what's to improve?

IDG UK Sites

Sony Xperia Z3+ (UK Sony Xperia Z4) UK release date, price and specification: Pre-order the Sony Xp9......

IDG UK Sites

Why Intel’s vision of the future is a future I want to live in

IDG UK Sites

What Jony Ive's new job means for Apple design

IDG UK Sites

Jony Ive 'semi-retired' into new role: kicked upstairs as Chief Design Officer