VBA Oracle connection without Oracle client

[SimonSellick]

Hi,

I know this has been asked and answered many times, but I wonder whether anything has changed in the last few years?

We have locked-down PCs with no user permission to install anything at all, but MS Access is available. I need to create a front-end that connects to an Oracle database and it would be useful if I did not have to specify Oracle client software as a pre-requisite. Does anyone know if there is a way to achieve that yet that does not involve creating compiled code? My development tools are very limited (VBA), so COM is out. I use Oracle's SQL Developer tool, and that seems to manage by using its own JDBC driver - is there perhaps a way that I can harness that?

Any suggestions gratefully received.

Simon.

 

[boblarson]

The problem is that the Oracle ODBC driver is not installed by default in Windows. So, you need to add the Oracle client in order to get the ODBC driver. I ran into that similar issue in the past and had to install the client to get the driver.

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com