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!