FM13 to view MS Access table

[Scott Pon]

I'm at a loss, or maybe I overt-thinked this or missed the obvious answer.

I have a Filemaker 13 Database on a Filemaker Server.  I also have some additional data in MS Access.  A user has requested to show some MS access data on to the FM database.  So I created a ODBC connection.  and connected it to my test access db.

Attempt #1: I created a test FM file.  I started with "Import Records"-> "ODBC Data Source".  I selected my Data Source.  It asks for Username / PW.  I get to "SQL Query Builder".  
BUT: when I select the table, the Columns' box does not fill in.  I checked the Access DB and gave "Users" Administrator Access.  but still this box does not fill in.

Attempt #2: Manage-> External Data Sources.  I click "New".  I choose "ODBC".  for DSN I selected my ODBC Source.  For simplicity sake, I left Authentication as "Prompt for username and password"  I clicked "OK. It added to the External Data Sources list.
BUT: when I go to Manage -> Database and tried to add to the relationship, it goes "The ODBC Data Source you have selected is not supported" then I'm stuck

So is this possible, having Filemaker add an Access as a data source?

 

[Kris M]

Data sources supported in FileMaker 14.0

You can use the following data sources in the FileMaker Pro relationships graph. If you are importing ODBC data, or using the Import Records or the Execute SQL script step, you can use additional data sources, such as IBM DB2 or Informix ODBC.

•

Oracle

•	Microsoft SQL Server

•	MySQL Community Edition (free)

For information about the supported versions of these ODBC data sources, search the FileMaker Knowledge Base available at http://help.filemaker.com. For an overview of the various ways of working with ODBC data sources, see Using ODBC and JDBC with FileMaker Pro.

Note  If you’re using the 32-bit version of FileMaker Pro, you must use a 32-bit ODBC client driver; if you’re using the 64-bit version of FileMaker Pro, you must use a 64-bit ODBC client driver.

[Scott Pon]

Thanks for the info.  after digging through what you listed, it is NOT possible to link Access to FIlemaker in this way (Access as external data source)

Here's a list of accepted data sources:
http://help.filemaker.com/app/answers/detail/a_id/6420/kw/supported%20data%20sources

And Access is not one of them.