How to connect to oracle tables

[marathonlady]

This is my first time using an access database to link to oracle tables. What's the verbage needed to connect to the tables?

Thanks

 

[jfgambit]

You can use the ODBC connections in Windows to connect to Oracle tables.

Check this article about Oracle ODBC Drivers for Windows:

http://support.microsoft.com/default.aspx?scid=kb;en-us;147192

And this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;208295

Also, when creating queries to ensure that you do not receive "time-out" errors when running against the Oracle tables make sure to change the ODBC Timeout Property in the Query from 60 to 0.

HTH

Jeff