The easiest thing to do is to install the Oracle Client software on your workstation. This will install the ODBC driver. In Control Panel->Administrative Tools, there is an ODBC manager. With this tool, you can Add a new ODBC Data Source Name (or DSN). Now go to MS Access and choose File->Export. In the Save File As box, choose ODBC Datasources(). The wizard will then ask you which DSN to use. Use the DSN you created above.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.