Jump to content

FileMaker 14 as data source to MS Access


This topic is 3038 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Screen Shot 2015-11-09 at 10.40.49 AM.png

Link to comment
Share on other sites

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 by ggt667
Link to comment
Share on other sites

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.

 

Link to comment
Share on other sites

This topic is 3038 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.