I am trying to link MS Access 2007 to a Filemaker Pro Advanced 11 file. I get to a point where it asks me to test the connection which is successful. However, when I click next and enter the user name and password I get error 802 - cannot connect to file. I have tried two different files (one is the sample file that comes with filemaker) with the same result.
The Filemaker file is open and ODBC is enabled. The ODBC driver seems to be installed correctly.
Why doesn't it work.