User manual
Table Of Contents
- Chapter 1 Introducing FileMaker Pro
- Chapter 2 Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Working with data in Table View
- Finding records
- Performing quick finds in Browse mode
- Making find requests in Find mode
- Finding text and characters
- Finding numbers, dates, times, and timestamps
- Finding ranges of information
- Finding data in related fields
- Finding empty or non-empty fields
- Finding duplicate values
- Finding records that match multiple criteria
- Finding records except those matching criteria
- Viewing, repeating, or changing the last find
- Saving find requests
- Deleting and reverting requests
- Hiding records from a found set and viewing hidden records
- Finding and replacing data
- Sorting records
- Previewing and printing databases
- Automating tasks with scripts
- Backing up database files
- Setting preferences
- Chapter 3 Creating databases
- Planning a database
- Creating a FileMaker Pro file
- Creating and changing fields
- Setting options for fields
- Creating database tables
- Creating layouts and reports
- Setting up a layout to print records in columns
- Working with objects on a layout
- Working with fields on a layout
- Working with parts on a layout
- Displaying data in charts
- Chapter 4 Working with related tables and files
- Chapter 5 Sharing and exchanging data
- Sharing databases on a network
- Importing and exporting data
- Saving and sending data in other formats
- Sending email messages based on record data
- Supported import/export file formats
- Setting up recurring imports
- ODBC and JDBC
- Methods of importing data into an existing file
- About adding records
- About updating existing records
- About updating matching records
- About the importing process
- Converting a data file to a new FileMaker Pro file
- About the exporting process
- Working with external data sources
- Publishing databases on the web
- Chapter 6 Protecting databases
- Protecting databases with accounts and privilege sets
- Creating accounts and privilege sets
- Viewing extended privileges
- Authorizing access to files
- Security measures
- Enhancing physical security
- Enhancing operating system security
- Establishing network security
- Backing up databases and other important files
- Installing, running, and upgrading antivirus software
- Chapter 7 Converting databases from FileMaker Pro 6 and earlier
- Index
124 FileMaker Pro User’s Guide
You can define privileges in a shared file while clients are using it. Any privilege changes that affect a current
client do not take effect until the client closes and reopens the file.
The privileges that you set up apply to a single file only and all database tables within that file. If your
database solution consists of multiple files that you want to protect, you may want to combine all of these
files into one multi-table file. Then you can define privileges in only a single file to manage access to the
entire database solution. If you don’t want to combine the files into one file, then you should define
privileges in each file that contains items you want to protect.
Important If you create a relationship in one file that references a table in another file, you cannot manage
access privileges for the related table in the first file. The privileges defined in the other file control access
to that table.
Accounts, privilege sets, and extended privileges
This section describes FileMaker Pro accounts, privilege sets, and extended privileges.
For more information on sharing data, see chapter 5, “Sharing and exchanging data.”
Accounts
Accounts authenticate users who are attempting to open a protected file. Each account specifies an account
name and usually a password. Any user that cannot specify valid account information won’t be able to open
a protected file.
Each database file contains two predefined accounts: Admin and Guest. For more information, see “About
the predefined accounts” on page 125.
You may want to create an account for every individual who accesses a file, or you may want to create a
small number of accounts that are shared among many individuals, such as a “Marketing” account and a
“Sales” account.
1 Create accounts for individuals when it is necessary to verify the identities of particular users and you
want to manage access at an individual level.
1 Create shared accounts when you want fewer accounts to maintain and you are less concerned about
managing individual access to the database file.
If you host files on FileMaker Server, you can create External Server accounts that obtain authentication
information from an authentication server such as an Apple OpenDirectory or Windows Domain. For more
information, see
“Creating accounts that authenticate via an external server” on page 131.
Privilege sets
A privilege set specifies a level of access to a database file. Each database file contains three predefined
privilege sets for common types of access levels: Full Access, Data Entry Only, and Read-Only Access.
When you create a privilege set, there are many options available that you can use to limit database access,
such as which layouts are viewable, which menus are available, and whether printing is permitted. Privilege
sets can also restrict access to records or fields from particular tables within a file. Each account is assigned
a privilege set, which determines the level of access when someone opens a file using that account.
You can create as many privilege sets as you need to define the types of access you want to permit to a file.
For more information about privilege sets, see
“About the predefined privilege sets” on page 126.