[oracle][odbc][ora]ORA-00942: table or view does not exist (#942)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

simple_tree_hugger - 24 Aug 2005 15:04 GMT

Wednesday, August 24, 2005 9:43 AM
--------------------------------------------

My MS-access DB consists of only LINKED tables to our PRODUCTION Oracle DB.
I was always able to see the contents of a table in datasheet view. Now, all
of a sudden, I get an error. All I did was add an additional item to my
tnsnames.ora file to include a TEST DB which I may need to use later.
Nothing to do with this operation and error:

MS office Access > Could not execute query ; could not find linked table.
[oracle][odbc][ora]ORA-00942: table or view does not exist (#942)

Everything seems to work fine via SQL+ connecting directly to the oracle DB

>> all is well on the back-end.

My ODBC data source connection configuration is unchanged from the good old
days. Please help urgently. Thanks !!!

-- cliff2noronha at gmail dot com

--------------------------------------------

Reply to this Message

oozyscab - 24 Aug 2005 22:55 GMT

Try refreshing the link to the table. I've experienced where changes were
made to an Oracle table or view (and were not communicated to me) and had the
same problem as you describe. Go into the Linked Table Manager and select
all the tables/views and don't check the box to prompt for a new location.
Hopefully this helps.

Eric

>Wednesday, August 24, 2005 9:43 AM
>--------------------------------------------
[quoted text clipped - 17 lines]
>
>--------------------------------------------

Reply to this Message