Access to reach Oracle database with ODBC
Hello oracle community,
Oracle 11.1.0.7.0, Access 2007:
We have an ODBC driver to connect to the oracle database over access. it is working fine, just when we open two instance of access on the same machine, two connections (over same ODBC) to different schema/users and starting a query, he is not able to find the tables of the second connection. it seems like he is using the wrong user. is there any solution or anything we are doing wrong ?
Ikrischer