ODBC, Access: Pass-Through?

HELP! HELP! I'm using MSACCESS 7.0, ORACLE 7, INTERSOLV ODBC Drivers, WIN NT and WIN 95

I create two SQL Pass-Through queries:

Query 1

sql = "SELECT TABLE_NAME FROM USER_TABLES" Connect string = "ODBC;DSN=INTERSOLV;UID=Stephan;PWD=coco;SERVER=ORCL;"

Query 2

sql = "SELECT TABLE_NAME FROM USER_TABLES" Connect string = "ODBC;DSN=INTERSOLV;UID=Roger;PWD=nuts;SERVER=ORCL;"

The Problem

First, I run Query1, and it returns me the name of the tables in Stephan space.
Then, I run Query2 and it returns me the same table names! If I want Query2 to run correctly, I have to close Access and re-open it.

I know that I could create a query such as "SELECT TABLE_NAME .... WHERE OWNER = .." but it's not the point.
The point (and question) is:

How do I programatically connect in the same session as a different user? How do close an open session?

Any Specialist?

(Please send me email at stephane_at_chiche.com) Received on Thu Aug 22 1996 - 00:00:00 CEST