AnsweredAssumed Answered

ODBC Connection to MS Access error

Question asked by StephBell on Sep 5, 2016
Latest reply on Sep 6, 2016 by user19752

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!

 

Thanks,

Steph

Outcomes