I work at a small manufacturing company that has an ERP called DBA Manufacturing. It is a SQL Firebird flat relational database. I thought I understood what that meant at some point, but I am finding that this database is set up with primary keys and foreign keys in the tables just like my Access works. So I really don't understand the "flat" at all.
I have tried to set up the connection several times and at some point I had the 32 bit connection to DBA testing successful in the ODBC Data Source Administrator. At that time I had uninstalled the 64 bit driver. As soon as I reinstalled that driver I went back and tested the 32 bit connection and it failed. I can see both drivers in the program list in Control Panel/Uninstall programs, but the have exactly the same name. When I look at the driver list in the DSA it only shows one driver.
Everything I can find on this says that the Access needs to use the 64 bit driver and the DBA needs to use the 32 bit driver. How do I get them to do that? A programmer friend of mine says I should look in the Access program settings for a specific driver setting.