FileMaker 14 as data source to MS Access

[mr_mike]

I have a client that would like to use MS Access to connect to a table in a solution hosted on FMS 14.0.3.  What I'm reading suggests that was possible with .fmp5 and .fmp7 but is no longer available in .fm12.  I've tried to use Access and both (mac) Excel and (windows) Excel to connect via ODBC to the FMS hosted table and I can construct the query and see the fields, but when I submit the request I get an error.  Is it still possible to connect Excel or Access to FileMaker 14.0.3 (hosted)?  The error I get appears on the attached screenshot.

Is anyone currently doing this?  

Thank you in advance.

[ggt667]

Which parts of your solution is running on which operating systems? I have only been able to make Excel work with ODBC on the Windows platform myself.

Edited November 10, 2015 by ggt667

[Wim Decorte]

Excel to FM should work just fine, the FTS Advanced book for FM14 has a whole exercise that shows just that (using Mac Excel to Windows FMS)

Access should be the same since would be using the same FM driver.

Can you make it work by reducing the # of fields?  Perhaps that will help you track down if there is a data issue in one of those fields.

 

[mr_mike]

Wim - thank you!  Downloading it now.