Accessing Oracle database

[rbodhale]

Hi,
I am new to MS access VBA.
I have a code which is accessing data from the Oracle production database server. To the same code I want to add new functionality and to test that functioanlity I want to access data from Oracle developent database, but when I gone through the code, I did not find any connection between application and oracle database but still the application is accessing data from production database. So can any body tell me,



1) How the application is accessing data from production database ? (Even I did not find connection between database and application)
2) If I want to access developement database, how can I access the data from Oracle database from my MS Access VBA application ? ( Note: I did not find any connection between MS access VBA code and oracle database)
3) Any help in this regard will be grate help for me.

[orange]

Talk to the people who manage the Oracle database you are accessing.
They will understand tnsnames and ODBC connections, and will help you with the proper set up and constraints..