1 Reply Latest reply on Nov 14, 2011 1:49 PM by acwei

    Linking to MS Access database tables



      Linking to MS Access database tables


      My POS system has an Access backend.  I currently use MS Access to link to the POS backend tables to run queries and reports.  I would like to do the same using FM.  I have managed to set up the ODBC connection with DSN so I can see the Access DB file from "Manage External Data Sources".  However, when I try to use "Manage Database - Relationships" to display the tables, I get error message saying "The ODBC data source you have selected is not supported."  I'm pretty sure this is a simple fix but I can't figure it out.  Help!!!!