Connection to Oracle from Access97..

[bnath001]

Hi,

I have been using Access97 tables and I used to use
set dbtemp = currentdb()
set rst_table = dbtemp.openrecordset("tbl_test&quot

to connect to the tables. But now I have moved the table to oracle. I have created a DSN using ODBC administrator.
How to connect to oracle using the code.

could some give me some suggestion.
thanks

 

[GingerR]

you could use a pass-thru query (stores ID and password) or link directly to the table with File-Get External Data-Link.

 

[bnath001]

How to use Pass thru query ? (connecting to oracle from Access97).

currently I have linked Oracle tables into my access97 application using LInked table manager.

thank you
nath