Multiple ODBC Queries

[Jackson via AccessMonster.com]

Hi,

I'm developing a DB in Access that will need to query (at the moment) 2
different Oracle sources. The queries run fine individually, however, when I
open Access, run Query1 it will run fine, close query, run Query2 I get:

ODBC--call failed: [Oracle][ODBC][Ora]ORA-00942: table or view does not exist
(#942)

If I close access, and reopen, then run Query2 I'll get it's results no
problem, close and run Query1 and it will return the same error message.
Incidently, queries based on the same source have no problem running
sequentially.

Is there an easy way to close my ODBC connection via code to see if that will
remove this (quite irritating) problem or does anyone have any suggestions
where I'm going wrong?

Many Thanks,
Jackson.

 

[Jackson via AccessMonster.com]

It seems queries on the same source can get the same problem, I don't
understand what is going on. Sometimes it will let me run Query1 and 2 from
different sources in the same session but then not 3 &4 which are from the
same source as 1...

The only guaranteed way to make it run is close access and re-open it?

 

[abdalwahab]

Hi,

I'm developing a DB in Access that will need to query (at the moment) 2
different Oracle sources. The queries run fine individually, however, when
I
open Access, run Query1 it will run fine, close query, run Query2 I get:

ODBC--call failed: [Oracle][ODBC][Ora]ORA-00942: table or view does not
exist
(#942)

If I close access, and reopen, then run Query2 I'll get it's results no
problem, close and run Query1 and it will return the same error message.
Incidently, queries based on the same source have no problem running
sequentially.

Is there an easy way to close my ODBC connection via code to see if that
will
remove this (quite irritating) problem or does anyone have any suggestions
where I'm going wrong?

Many Thanks,
Jackson.