FileMaker ODBC Problem "Unable to open file" (error code #802)
I am working with FileMaker Pro Advanced v11.
I would like to use FileMaker database and working with Excel via OBDC.
I've follow the "ODBC JDBC Guide" to setup ODBC, and I am sure everything was well setting.
I've tested when I finished setting ODBC client driver, and test completed successfully.
I can also connect the ODBC client driver using FileMaker (import ODBC database).
The problem is, I can't conncet Filemaker database via ODBC with Excel, Access and Word...
It shows up the error "Unable to open file (#802)" for all MS Office software...
I can't understand...why I can connect database via OBDC with Filemaker but not MS Office software?
I've Google for 3 hours...But can't find any solution...
Dose anyone know what happen and how to solve this problem?
Operation System: Windows 7 SP1