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

[Guest]

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
My ODBC data source connection configuration is unchanged from the good old
days. Please help urgently. Thanks !!!

-- cliff2noronha at gmail dot com

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

 

[oozyscab via AccessMonster.com]

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
--------------------------------------------

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
My ODBC data source connection configuration is unchanged from the good old
days. Please help urgently. Thanks !!!

-- cliff2noronha at gmail dot com

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