I have created 3 User DSNs… One for each of the 3 companies I am tracking business on in Navision. I use MS Access to create Adhoc reports… However, I link to one Company but another Company’s data is showing. Any ideas??
C/ODBC Driver is not thread safe. You can’t connect to multiple companies with the same EXE. If you open 3 copies of MS Access, then you will be OK, but that’s not what you want. The easiest way to solve this is by using a product like ‘Easysoft ODBC-ODBC Bridge’. Once you install it, change its configuration to run in Multi-process mode(Not the default), see here: http://www.easysoft.com/products/9999/faq_answer.phtml?ID=93&product=2002 Another solution is to upgrade to the SQL version and bypass the C/ODBC driver all together. You will be using MS SQL ODBC Driver rather than Navision’s C/ODBC Driver.