FileMaker 12 connection to a series of Access db tables
Posted on 2013-01-05
(very, very) new at this with no experience in Filemaker pro (but hey, i bought it because its advertised as so easy.)
To start the project, I need to connect FileMaker to a series of existing Acccess tables that were split back end and front end. The best outcome is to connect Filemaker to the production Acccess tables in a read only mode, so that users can continue to use access front end reports & data entry, while new fancy web enabled reports can be developed in Filemaker (intent is Filemaker will not do data entry, just reporting.)
Been stymied by the ODBC connections for Filemaker to Access, right out of the gate. The development machine with Filemaker is win7 64 bit and the Access is 2010 32 bit. Have uncovered the weirdness of where MS chose to put the OBDC console for 32 bit office on Win7 and have seemingly created an ODBC driver for the Access tables, but Filemaker balks with the simple statement "The ODBC data source you have selected is not supported", so clearly I don’t know what I'm doing (new, newbie.)
Short version? Anyone offer a step by step advice on connection Filemaker (Read Only?) to Access tables to get me to the next newbie level?