ODBC and JDBC Guide

Chapter 1 | Introduction 8
Limitations with third-party tools
Microsoft Access: When using Microsoft Access to view data in a FileMaker data source, do not
use data from a summary field. The summary field’s data should not be edited in Microsoft Access,
and the data value that is displayed in Microsoft Access may not be accurate.
Networking requirements
You need a TCP/IP network when using FileMaker Server to host a FileMaker database file as a
data source over a network. FileMaker Pro Advanced supports local access (same computer)
only. FileMaker Cloud connections may be limited by the Amazon EC2 instance type and app
design.
Updating files from previous versions
If you installed a driver from earlier versions of FileMaker Pro Advanced or FileMaker Server, you
must install the driver for the current version. The driver for the current FileMaker version is not
compatible with earlier versions.
See chapter 3, “Installing FileMaker ODBC client drivers,” and chapter 5, “Installing FileMaker
JDBC client drivers.”
Notes
1 You have to create a Data Source Name (DSN) for each FileMaker database file you want to
access as a data source. If you have previously set up access through one DSN that allows
tables to be spread among several FileMaker database files, you’ll need to consolidate those
tables into a single database file (or create several DSNs).
1 For information on using ODBC and JDBC with previous versions of FileMaker Pro Advanced,
see the Product
Documentation Center.