1.7 Sharing and exchanging data

1.7 Sharing and exchanging data

The advantage of FileMaker Pro is that you can share your data with other users. You can share your data with other FileMaker Pro or FileMaker Go users on a network, use the web publishing features to share data over the web, or import or export data from another file. In addition, you can use ODBC (Open Database Connectivity) and JDBC (Java Database Connectivity) to share FileMaker Pro files with ODBC- and JDBC-enabled applications, or access data from external data sources. This makes it possible to easily connect gFM-Business to other database systems.

If your computer is connected to a network, you and other FileMaker Pro or FileMaker Go users on Windows and Mac OS can use the same FileMaker Pro database at the same time. FileMaker Pro Network Sharing supports file sharing by up to nine users simultaneously.

Note: If you want to share files with more than nine users at the same time, FileMaker recommends using FileMaker Server.

You can set up a FileMaker Pro file to automatically update data imported from another application (such as Microsoft Excel). Recurring import is performed automatically the first time you view the layout that contains the data from the external file. Later, you can run a script to update the data.

1.7.1 Saving and sending data in other formats

FileMaker Pro lets you save data in various file formats, such as Microsoft Excel spreadsheets and Adobe PDF files, so you can send the files to users who don't have FileMaker Pro. You can send the files automatically by e-mail after you have saved them.

1.1.2 Protecting databases

You can restrict what users can see and do in a database file by defining accounts and permissions. Accounts authenticate users who try to open a protected file. Each account specifies an account name and (usually) a password. Users who cannot provide valid account information will not be able to open a protected file. Permissions specify an access level to a database file. Each account is assigned a permission that determines the access level for people who open a file with that account. Extended access rights determine the data sharing options that an authorization allows, e.g. whether users can open a shared file or view a database in a web browser.