Change ODBC Data Source Name on the Fly Programatically

T

tkosel

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedded Excel into Word with Tables 0
Embed the same Excel multiple times 0
ODBC Connection 0
Manage ODBC 2
ODBC Connection to Oracle database is very slow 0
Error 3298:More than one table exists with same name 2
ODBC Linked tables keep on getting error 3151 5
Changing ODBC Data Source for linked tables 4

Top