I was just wondering if it is possible to connect an Access database to an Oracle application. If so, could you tell me how? I have recently connected an Access database with DB2 tables and would like to do something similar with Oracle.
Link Access to Oracle
- Thread starter LadyDi
- Start date
Thank you very much for the reassurance. I googled an ODBC driver, and got several results. How do I know what a good one to download is? Is there anything specific I should look for? Is it just and ODBC driver, or does it need to be specific to Oracle?
MSAccessRookie
AWF VIP
- Local time
- Today, 16:27
- Joined
- May 2, 2008
- Messages
- 3,428
ODBC Drivers are usually specific to the Database that you are connecting to, so in your case, you would look for the ODBC Driver that is associated with the version of Oracle that you will be using.
I use Access to extract data from a very large Oracle database. Since I am just an end user, I have to make do with what the IT department has provided. The Oracle ODBC driver that comes with Windows XP Professional is more than adequate.
MSAccessRookie
AWF VIP
- Local time
- Today, 16:27
- Joined
- May 2, 2008
- Messages
- 3,428
If your IT department supplies you with resources like ODBC Drivers, then go with whatever they recommend. You might want to also understand, that since each version of Oracle could require a different driver, that future upgrades to Oracle could bring you back to your IT department again.
Similar threads
