[Oracle][ODBC][Ora]Ora-00942 Table or view does not exist (#942)
Why do I get this message when trying to ling a table to an access database
I get this error when I use Oracle ODBC Driver. The table pop up and i can select from the list but when i select one I get this error
[Oracle][ODBC][Ora]Ora-00942 Table or view does not exist (#942)
When I try using Microsoft ODBC for Oracle it does not pull up any tables.
Solution: [Oracle][ODBC][Ora]Ora-00942 Table or view does not exist (#942)
The account that you are using to access the Oracle database may not have priviledges for the table/view. Try accessing the table from sqlplus using the same account. If you can't access it there then you need to change the priviledges of the account or use and account that does have priviledges to the table/view.