<div id="popup_box_thanks" style="display:none" onClick="close_popup_thanks('popup_box_thanks', 'ts')"><br>Thanks for submitting your tip! All submissions are moderated by an editor before appearing online. We've reset the form so you can enter another tip. Or you can close the tip submission box. <div class="x_close" id="thanks_upper_right"><a href="javascript:void(0)" onmousedown="close_popup_thanks('popup_box_thanks', 'ts'); return true;">Close</a></div></div>
<div class="tbf_row"><div class="tbf_wide_extra_top not_bold">Please submit only technical tips that will help other TidBITS readers better use their Macs, iPhones, and related software and hardware. All product announcements should be sent to <a href="mailto:releases@tidbits.com">releases@tidbits.com</a>.</div></div>
<div class="tbf_left">URL</div><div class="tbf_right"><input type="text" value="" name="tip_link_url" tabindex="3"><span class="tip_description"><br>Enter the URL to a Web page that supports your tip.</span></div>
</div>
<div class="spacer"></div>
<div class="tbf_row">
<div class="tbf_left">Linked text</div><div class="tbf_right"><input type="text" value="" name="tip_link_label" tabindex="4"><span class="tip_description"><br>Enter the name of the page linked above.</span></div>
<div class="tbf_wide"><input type="submit" value="Preview Your Tip" name="preview_tip" onClick="fill_preview('tipbits_enclosure_preview', 'ts', this.form); return false;" tabindex="7"> <input type="submit" value="Send Us Your Tip!" name="submit_this_tip" onClick="handle_tip_submission('ts', '', this.form, 'tip'); return false;" tabindex="8"></div>
</div>
<div class="spacer"></div>
<div class="tbf_row">
<div class="tbf_wide"><span class="fine_print">When you submit a tip, you give us permission to use it. Read <a href="javascript:void(0)" onClick="generic_show_hide('tip_terms')">our terms</a> for more details. All submissions are reviewed before publication.</span></div>
<div class="tbf_wide"><span class="fine_print">Our terms: By submitting a tip, you agree to assign TidBITS Publishing Inc., a non-exclusive, worldwide, perpetual license to reproduce, publish, and distribute your tip in connection with the TidBITS Web site and associated products in any media. You agree that you created the content you submitted, and that you have the right to assign us this license. You give us permission to use your name, but your email address won't be publicly displayed or shared. We review all submissions before publication, and reserve the right to select which submissions we feel are appropriate for our readers and to edit those we publish.</span></div>
<div id="comment_thanks" style="display:none" onClick="close_popup_thanks('comment_thanks', 'comm')"><br>Thanks for submitting a comment! Please check your email for a link that, when clicked, will verify that you're a real person and cause your comment to appear immediately. <div class="x_close" id="comment_upper_right"><a href="javascript:void(0)" onmousedown="close_popup_thanks('comment_thanks', 'comm'); return true;">Close</a></div></div>
<div class="tbf_wide"><span class="fine_print">Our terms: We reserve the right to edit or delete any comment, so please post thoughtfully. We use your email address <i>only</i> to send you a one-time verification message confirming that you posted this comment. We also store your address to allow you to verify using other Web browsers in the future. For more info, see our <a href="http://db.tidbits.com/privacy.html">privacy policy</a>.</span></div>
<li><a href="/feeds/tidbits.rss" title="Subscribe via RSS" class="gettb">RSS <img src="/images/feed-icon-12x12.gif" width="12" height="12" border="0" class="nav_img" alt="Subscribe via RSS"></a></li>
<li><a href="http://itunes.apple.com/WebObjects/MZStore.woa/wa/viewPodcast?id=276986548" title="Subscribe to the podcast" class="gettb">Podcast <img src="/images/feed-icon-12x12_podcast.gif" width="12" height="12" border="0" class="nav_img" alt="Subscribe to the postcast"></a></li>
<li><a href="http://www.twitter.com/TidBITS" title="Get Article Updates via Twitter" class="gettb">Twitter <img src="/images/feed_icon_12x12_twitter.png" width="12" height="12" border="0" class="nav_img" alt="Get Article Updates via Twitter"></a></li>
<li><a href="http://www.facebook.com/pages/TidBITS/195314925519" title="Go to the TidBITS Page at Facebook" class="gettb">Facebook <img src="/images/feed_icon_12x12_facebook.gif" width="12" height="12" border="0" class="nav_img" alt="Go to the TidBITS Page at Facebook"></a></li>
<li><a href="javascript:void(0)" title="Sections" class="tabhead" onClick="return showhide('articleslist')">Sections <span id="articleslist_triangle"><img src="/images/nav_triangle_open.gif" width="9" height="9" border="0" class="navtriangle" id="articleslist_tri_image" alt="Click to show or hide the contents of this section."></span></a></li>
<li><a href="javascript:void(0)" onClick="return showhide('stafflist')" title="Staff" class="tabhead">Staff <span id="stafflist_triangle"><img src="/images/nav_triangle_closed.gif" width="9" height="9" border="0" class="navtriangle" id="stafflist_tri_image" alt="Click to show or hide the contents of this section."></span></a></li>
<li><a href="javascript:void(0)" title="Issues" class="tabhead" onClick="return showhide('issuelist')">Weekly Issues <span id="issuelist_triangle"><img src="/images/nav_triangle_closed.gif" width="9" height="9" border="0" class="navtriangle" id="issuelist_tri_image" alt="Click to show or hide the contents of this section."></span></a></li>
<li><a href="javascript:void(0)" onClick="return showhide('abouttidbits')" title="About TidBITS" class="tabhead">About TidBITS <span id="abouttidbits_triangle"><img src="/images/nav_triangle_closed.gif" width="9" height="9" border="0" class="navtriangle" id="abouttidbits_tri_image" alt="Click to show or hide the contents of this section."></span></a></li>
<div class="center_top">Thoughtful, detailed coverage of the Mac, iPhone, and iPad, plus the best-selling <a href="http://www.takecontrolbooks.com/?pt=TB-TAGLINE" style="color:yellow">Take Control</a> ebooks.</div>
<!-- begin centercolumn -->
<div id="centercolumn">
<!-- begin rightcolumn_container -->
<div id="rightcolumn_container">
<!-- begin rightcolumn -->
<!-- rightcolumn is embedded within centercolumn so featured text wraps around it -->
</div><!-- end tearoffbox_wide_container for watchlist items -->
<!-- begin tearoff box wide -->
<div class="tearoffbox_wide_container">
<div class="tearoffbox_wide_tips">
<div class="tip_display">
<div class="tips_sponsor_logo">
</div>
<h6>Calculate with Spotlight</h6>
<p><p>Have a quick calculation to perform? Don't bother opening Calculator, simply enter the calculation into Spotlight's search bar, and Spotlight displays the answer as the top item. To perform further calculations, hit Return, or click the answer, and Spotlight launches Calculator.</p></p>
<div class="tbf_wide_80" id="hc_rc_4250">To help us avoid automated posts and misuse of our site, please enter the words below.</div><div class="x_close_row" id="hc_upper_right2_4250"><a href="javascript:void(0)" onmousedown="HidePopupContent('hc_4250', 'hc', '4250'); return true;">Close</a></div>
<div class="featured_meta"><div class="meta_article">27 Sep 1999 | <a href="/article/5576?print_version=1">Print <span class="shift_up"><img src="/images/printer_icon.gif" alt="Printer-Friendly Version of This Article" border="0" width="9" height="10"></span></a></div></div>
<H2>FileMaker Pro 5 Released to Controversy</H2>
<p class="byline">by <a href="/author/Adam%20C.%20Engst">Adam C. Engst</a> <a href="javascript:void(0)" onClick="document.check_human_4250.submit_type.value='email'; document.check_human_4250.author_id.value='6'; ShowTipBox('hc_4250', 'hc_recaptcha_4250')"><span class="shift_down"><img src="/images/gettb_button_email.gif" height="12" width="12" border="0" alt="Send Email to Author"></span></a> and <a href="/author/Geoff%20Duncan">Geoff Duncan</a> <a href="javascript:void(0)" onClick="document.check_human_4250.submit_type.value='email'; document.check_human_4250.author_id.value='15'; ShowTipBox('hc_4250', 'hc_recaptcha_4250')"><span class="shift_down"><img src="/images/gettb_button_email.gif" height="12" width="12" border="0" alt="Send Email to Author"></span></a></P>
<!-- article text -->
<div id="article_box_4250"><P>Upgrades are different things to different people, and how you'll view the FileMaker Pro 5 upgrade, available today, depends on how you use the popular desktop database program. If you use FileMaker as a small stand-alone database, you may be interested in upgrading, and small office users considering FileMaker Pro's built-in Web publishing features also have reason to investigate the $150 upgrade ($250 for new copies). However, many FileMaker Pro developers and existing Web publishers are dismayed at the new version, which reduces or eliminates capabilities present in previous versions of FileMaker Pro, adds few necessary new features, and fails to offer many features users have been requesting for years.</P><P><<A HREF="http://www.filemaker.com/products/">http://www.filemaker.com/products/</A>></P><P><STRONG>New Features</STRONG> -- Individual users accustomed to Microsoft Office may appreciate FileMaker Pro 5's reworked interface, which resembles that used by the Microsoft Office applications. Since many people end up using Microsoft Excel for tasks better done in a database because of the ease of viewing data in a spreadsheet, FileMaker Pro 5 adds a new spreadsheet-like view of records with resizable rows and columns. FileMaker, Inc. also enhanced the program's Web publishing support for those getting their feet wet putting databases on the Web. FileMaker Pro's enhanced Instant Web Publishing technology now supports Cascading Style Sheets (CSS), adds seven selectable "Web themes" to unify the presentation of databases published via the Web, and offers new security restrictions based on IP addresses. FileMaker Pro 5's Web Companion can also transfer data using XML (Extensible Markup Language), which could offer a wealth of new possibilities for XML-savvy Web browsers and other tools, although such tools are almost unheard-of outside Web developer circles at the moment.</P><P>In a move that presumably indicates the demise of FileMaker's Web page creation tool Home Page, FileMaker has also announced that Adobe GoLive, Macromedia's DreamWeaver, and Allaire's ColdFusion plan to integrate support for Web publishing with FileMaker databases.</P><P><<A HREF="http://db.tidbits.com/article/04787">http://db.tidbits.com/article/04787</A>><BR><<A HREF="http://www.adobe.com/prodindex/golive/">http://www.adobe.com/prodindex/golive/</A>><BR><<A HREF="http://www.macromedia.com/software/dreamweaver/">http://www.macromedia.com/software/dreamweaver/</A>><BR><<A HREF="http://www.allaire.com/Products/ColdFusion/">http://www.allaire.com/Products/ColdFusion/</A>></P><P>FileMaker Pro 5 also enhances FileMaker Pro 4.1's ODBC (Open Database Connectivity) capabilities. ODBC, which is a database communication standard, enables database programs from different vendors to exchange information. FileMaker Pro 4.1 had ODBC client capabilities, so users could import data from ODBC data sources like Microsoft Access, Microsoft Excel, Microsoft SQL Server, or Oracle. Now, FileMaker Pro 5 can act as an ODBC data source as well, so other programs can access information stored in FileMaker databases, although FileMaker Pro 5.0 does not offer full OBDC Level 2 support, restricting its utility in some environments. FileMaker's ODBC features, along with the program's new XML capabilities, also help provide integration with Web page creation tools.</P><P><<A HREF="http://db.tidbits.com/article/05091">http://db.tidbits.com/article/05091</A>></P><P>FileMaker developers will appreciate a new database synchronization feature, the long awaited capability to import and export scripts, the capability to resize a few key dialogs like the ScriptMaker (finally!), and conditional value lists that let the developer dynamically customize choices in lists or menus appropriately to the situation.</P><P>FileMaker Pro 5 requires a PowerPC-based system with at least 16 MB of RAM running Mac OS 7.6.1 or later.</P><P><STRONG>Looking to the High End</STRONG> -- With these ODBC and XML features, it's clear that FileMaker, Inc. is taking aim at corporate and enterprise database users, and FileMaker, Inc. is changing the product's pricing model to work more like those used by other large database companies, who charge by user or by feature. Previously, FileMaker Pro has essentially been a standalone database: when you bought the program, you got everything no matter how you intended to use it. However, FileMaker, Inc. has now also announced three higher-end products, FileMaker Pro 5 Unlimited, FileMaker Server 5, and FileMaker Developer 5.</P><P>FileMaker Pro 5 Unlimited, scheduled to ship later this year for $1,000, will allow an unlimited number of guests and Web users to connect to databases and will provide remote database management via the Internet. FileMaker Pro 5 Unlimited's Web services are implemented via a Java servlet that hooks into popular Web servers (including WebSTAR, AppleShare IP, and Apache) plus supports Secure Sockets Layer (SSL) connections and arrays of computers sharing databases via additional copies of the Unlimited edition - this in turn enables FileMaker to offer load balancing, fault tolerance, and concurrent processing of database operations. FileMaker, Inc. claims the Unlimited edition will operate with third-party Web publishing and CGI solutions; the standard edition of FileMaker Pro 5 does not.</P><P><<A HREF="http://www.filemaker.com/products/fmu_home.html">http://www.filemaker.com/products/fmu_home.html</A>></P><P>The problem is that many of these attractive-sounding features, such as access by an unrestricted number of guests and Web users and compatibility with third party Web publishing solutions already exist in previous versions of FileMaker Pro. Unlike previous versions, FileMaker Pro 5 only supports peer-to-peer networking with up to ten other users, or up to ten IP addresses in a given 12 hour period. In addition, although it's nice that FileMaker, Inc. added shared database support for arrays of computers, users can already use separate machines and third-party products to add features like load balancing, fault tolerance, and concurrent processing to an existing FileMaker Pro 4.1 setup - we've done just that for our full-text searches of TidBITS. These multiple machine setups are necessary for some sites because previous versions of FileMaker Pro lack multithreading, which would allow the program to process multiple actions simultaneously, instead of on a first-come, first-served basis. FileMaker Pro 5 and FileMaker Pro 5 Unlimited continue to lack multithreading, although it has been perhaps the single most requested feature from Web publishers using FileMaker for nearly four years.</P><P>The end result is that the standard version of FileMaker Pro 5 is useless for anyone relying on Blueworld's Lasso or other third-party Web publishing solution. Since the FileMaker Pro 4.x built-in Web publishing features are limited in features and scalability, anyone who used FileMaker as part of a serious Web publishing system relied on a third-party product. FileMaker, Inc. is effectively telling those people they must use FileMaker Pro 5 Unlimited - which doesn't offer multithreading, isn't yet available, and costs $1,000 - simply to retain capabilities they already have. Adding salt to the wound, FileMaker Pro 5 uses a different file format than FileMaker Pro 3.x or 4.x; therefore, Web publishers who persist in using previous versions of FileMaker will not be able to serve databases created with FileMaker Pro 5.</P><P><<A HREF="http://www.blueworld.com/">http://www.blueworld.com/</A>></P><P>FileMaker, Inc. also plans to offer FileMaker Server 5 for $1,000 by the end of 1999. It will sport improved Open Transport performance under Mac OS 8.6 or later, automated database backups, and support for up to 250 concurrent database users. Although FileMaker Server 5 is a multithreaded application, previous versions of this high-end product have not offered Web publishing capabilities and have not worked with third-party Web publishing tools; nothing in FileMaker Server 5's product description indicates this situation has changed.</P><P><<A HREF="http://www.filemaker.com/products/fms_features.html">http://www.filemaker.com/products/fms_ features.html</A>></P><P>FileMaker Developer 5 will contain tools for distributing royalty-free runtime versions of FileMaker databases, documentation of FileMaker's XML capabilities, a new JDBC driver for Java-based integration with FileMaker solutions, and documentation of FileMaker's plug-in architecture. FileMaker Developer 5 includes a copy of FileMaker Pro 5 and should ship in early 2000 for $500.</P><P><<A HREF="http://www.filemaker.com/products/fmd_home.html">http://www.filemaker.com/products/fmd_home.html</A>></P><P><STRONG>Windows and a Hard Place</STRONG> -- It seems as though FileMaker, Inc. considers the Macintosh market essentially tapped out and is putting more emphasis on the Windows version of FileMaker Pro, with features designed to appeal to large organizations who might purchase volume product licenses. Aside from the Microsoft Office-inspired interface, the new spreadsheet-like data view, ODBC features, and direct import of Excel spreadsheets, FileMaker Pro 5 is taking direct aim at Microsoft's database product Access by offering tight integration with the Windows versions of Microsoft Office applications and support for application integration via ActiveX.</P><P><<A HREF="http://www.microsoft.com/office/access/">http://www.microsoft.com/office/access/</A>></P><P>FileMaker's long-standing dominance of the Macintosh database market means there are relatively few alternatives for Macintosh users. Users with modest needs can still use the database module of AppleWorks or ProVUE's Panorama. Those looking for more database power or Web publishing capabilities might try Panorama, ACIUS's 4D, Paradigma's Valentina, or even UserLand's Frontier (see "Frontier Demystified" in <A HREF="http://www.tidbits.com/tb-issues/TidBITS-476.html">TidBITS-476</A>).</P><P><<A HREF="http://www.provue.com/proVUE/PanoramaHome.html">http://www.provue.com/proVUE/PanoramaHome.html</A>><BR><<A HREF="http://www.apple.com/appleworks/">http://www.apple.com/appleworks/</A>><BR><<A HREF="http://www.acius.com/">http://www.acius.com/</A>><BR><<A HREF="http://www.paradigmasoft.com/">http://www.paradigmasoft.com/</A>><BR><<A HREF="http://frontier.userland.com/">http://frontier.userland.com/</A>><BR><<A HREF="http://db.tidbits.com/article/05351">http://db.tidbits.com/article/05351</A>></P><P>In the end, it's good to see FileMaker, Inc. enhancing its namesake product, although the directions the company has chosen seem to conflict with the ways FileMaker Pro has traditionally been used in the Macintosh market. The standard edition of FileMaker Pro 5 is not all things to all people, and the main question is whether or not users whose needs now fall into the $1,000 price range will find sufficient reason to upgrade.</P><!-- FileMaker Pro 5 Released to Controversy Adam C. Engst and Geoff Duncan --></div>
<!-- end article text -->
<!-- PayBITS -->
<p> </p><div class="sponsorbox">
<div class="sponsortext"><A HREF="http://markspace.com/bits?source=tidbits"><IMG SRC="http://db.tidbits.com/images/badges/mark-space.gif" ALT="" HEIGHT="50" WIDTH="50" BORDER="0" ALIGN="left"></A>SYNC YOUR PHONE with The Missing Sync: Sync your calendar,<br />address book, music, photos and much more between your phone<br />and Mac. Supports ANDROID, BLACKBERRY, PALM PRE and many<br />other phones. <<a href="http://markspace.com/bits?source=tidbits">http://www.markspace.com/bits</a>></div>
