|
Home > Archive > MS Access Database with External Data > August 2005 > [oracle][odbc][ora]ORA-00942: table or view does not exist (#942)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
[oracle][odbc][ora]ORA-00942: table or view does not exist (#942)
|
|
| simple_tree_hugger 2005-08-24, 9:24 am |
| 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[color=darkred]
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 2005-08-24, 8:26 pm |
| 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
simple_tree_hugger wrote:
>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
>
>--------------------------------------------
|
|
|
|
|