The easiest way to share your data is with FileMaker Network Sharing. If you already have a network in your office, and a few copies of FileMaker, you're ready to share your database. First, you put all your databases on one computer. Then open those files, change a few settings in each file, and call that computer the host. Every other computer that opens those files is called a guest, since it opens the same databases that are on the host. Up to five guests can connect to one host.
Once you're set up, all five people can work in the database at the same time, adding, editing, and deleting records, performing finds, printing, and running scripts. No two people can work in the same record at the same time, though. Once you're sharing files, you need to revisit the topic of record locking. See the box on Section 220.127.116.11 for a refresher.
18.1.1. Setting Up a Host Computer
To set up the host, open the databases you want to share on one computer. Then choose Edit Sharing images/U2192.jpg border=0> FileMaker Network (Windows) or FileMaker Pro images/U2192.jpg border=0> Sharing images/U2192.jpg border=0> FileMaker Network (Mac OS X). Either way, you see the FileMaker Network Settings dialog box: command central for all file sharing. Choose the database youre setting up from the list at left (if it's not there, make sure the file's open). Then, as described in Figure 18-1, turn sharing on.
Once you've turned Network Sharing on, turn your attention to the lower-right corner of the dialog box.
Choose one of the following three settings to control who gets access to the file:
When you make changes to these settings, FileMaker is actually making changes to the privilege sets in the selected file (Section 16.2). When you turn on "All users," FileMaker simply turns on the "Access via FileMaker Network" extended privilege for every privilege set. Likewise, if you choose "No users," it turns this extended privilege off for every set. When you specify people by privilege set, you get to decide which privilege sets have this extended privilege turned on. If you prefer, you can make these changes manually in Extended Privileges tab of the Define Accounts & Privileges window (File Define images/U2192.jpg border=0> Accounts & Privileges). Look for the [fmapp] extended privilege if youre setting access manually (Section 16.4.2).
Tip: You can control the access settings for each file even if you don't turn on network sharing. The settings you make to a file stick with that file even when you move it to another computer, so you can use this window to set the sharing options for a file before you send it to the host computer.
The "Don't display in Open Remote File dialog" option may seem odd at first, but it's actually very useful. Suppose you have a database system that's made up of several files, but you want your users to open only a specific one (because only one file has an interface and the others just hold data, for example). You want only that main file visible in the Open dialog box, so nobody opens the wrong one. Careful, though, you still need to share the other files. To share a file without showing it in the list, turn on the "Don't display in Open Remote File dialog" option in all the files you want hidden.
18.1.2. Opening a Shared File
Once you turn on network sharing and set it up to share at least one file, you can access that file from another computer. Just launch FileMaker Pro on another computer on the network, and then follow these steps:
Select the appropriate host from the Hosts list.
The shared files show in the Available Files list. (If the host computer you're looking for isn't listed, see the box on Section 18.104.22.168 for advice.)
If you've added accounts to the file, FileMaker asks you for an account name and password. When you give it what it needs, the database opens.
Note: When a database opens from a host, FileMaker puts the host name in parentheses in the window title bar to help you keep things straight. If you don't like seeing host names in your window's title bars, use the Set Window Title step to change that name in an open script.
Part I: Introduction to FileMaker Pro
Your First Database
Organizing and Editing Records
Building a New Database
Part II: Layout Basics
Advanced Layouts and Reports
Part III: Multiple Tables and Relationships
Multiple Tables and Relationships
Advanced Relationship Techniques
Part IV: Calculations
Introduction to Calculations
Calculations and Data Types
Part V: Scripting
Part VI: Security and Integration
Exporting and Importing
Sharing Your Database
Part VII: Appendixes
Appendix A. Getting Help