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!!!!
PS. I am currently running Windows 7 and MS Access 2003. And I am trying FM11. Don't know if this matters. Thanks for any help you can provide.