| | | tkosel |  |
|  Posted: Tue Sep 16, 2008 7:11 pm Post subject: Change ODBC Data Source Name on the Fly Programatically |  |
I have an access application that uses a query to get data from an Oracle
Database. (Tables are linked using ODBC.) I actually have the need to get
data from six different Oracle databases. Each client machine that will run
this application has six different Machine Data Sources defined, each with a
unique DSN name. The tables and fields in all six databases are identical,
only the data is different.
I have created a lookup table that contains the names of the six different
unique Data Sources. Is there a way that I can programatically change the
Data Source that Access will use when it accesses the linked tables? |
|
