title: Programatically create ODBC connection and link tables in MS Access
body: <p>We are using MS Access as a reporting front-end for Oracle. The data is accessed via an ODBC connection, and there are two linked tables in Access to Oracle that are the raw data tables. I'd like to be able to set up the connection and link the tables from within the Access file. That way users don't have to worry about setting up an DSN for the ODBC connection (most of them are not very technical users, and will require hand-holding for something like this), and we can eventually have the Access file point to different test environments and generate reports.</p>
  
  <p>Is it possible to have the database connection created dynamically when the file is opened, and can I dynamically change where my Linked Tables link to?</p>