1 2 Previous Next 17 Replies Latest reply on Sep 6, 2016 6:16 PM by user19752

    ODBC Connection to MS Access error


      Hello people of the FM Community,


           I am trying to link my solution to a MS Access 2010 DB file. I have set up the ODBC driver on the server to point to the file and the ODBC connection appears when in the application correctly. So good so far. However when I try and add a table from the connection i get this error:



      A few things to note:


      The FileMaker server is a different server to the one holding the MS Access file so it is connecting through a share:



      I am using a copy of the file for testing superposes.


      There is no username or password on the Access file or within it on the DB itself.


      I had an issue getting it to actually see the file because for some reason it was depending a network drive to be mounted, but found that if i edited the path in the registry of the FileMaker server it would let me put in the fill DSN name: \\pbasbsserver\pba\Fiance\SOP\PBAsopBE - Copy.accdb


      Any PC on the network can just double click the Access file (subject to them having Access installed) and it opens fine so not sure what I am doing wrong!


      Any help would be very much appreciated!




        1 2 Previous Next