I made a oracle base but i cannot access with Ms-Access 97.
I don't see the table, yet i put roles and rights..
I don't understant what happens.
Excuse-me i am french !!
Did you create the synonyms as well ?
How do you fetch data from Oracle . ODBC ? The setting are correct ? what kind of msg?
From ODBC 32bit help (for ORACLE7)
To access Oracle7 data, you must have:
The Oracle7 32-bit ODBC driver.
An Oracle7 RDBMS database. A network connecting the computers on which these reside, and a SQL*Net connection across that network.
Before you can access data with the Oracle7 32-bit ODBC driver, you must add a data source
for each of your copies of Oracle7 RDBMS.
On my Database it is the only way to access with MSAccess97.
[Edited by Tatyana on 11-17-2000 at 08:35 AM]
Impossible to connect with Access (Bis)
I create a synonym and i give autorisations.
I also create my DSN for ODBC connection.
For me, everything it's good.
Please help me for this problem.
What kind of messages did you got?
As to me sometimes running Easy Net Configuration with the same parameters
helped to solve problem (why???).
Click Here to Expand Forum to Full Width