<div>
<div class="content wysiwyg-content">
I have an MSAccess database that links tables to a SQL Server database via ODBC. &nbsp;I would like to dynamically link those tables when the database is opened to avoid having the user needing the ODBC entry on their PC. &nbsp;I can establish the link to the SQL Server database but from there, how do I LINK the tables.<br />
<br />
This is how I establish the connection to the sql server database. &nbsp;Can I use VBA code to link to the tables I need from here?<br />
&nbsp; &nbsp; &nbsp; &nbsp; strsql = &quot;Driver={SQL server}; Server=&quot; &amp;&nbsp;g_dbserver &amp;&nbsp;&quot;; Port=1433; Option=0; Socket=; Stmt=; Database=&quot; &amp;&nbsp;g_db &amp;&nbsp;&quot;; Uid=&quot; &amp;&nbsp;g_dbuserid &amp;&nbsp;&quot;; Pwd=&quot; &amp;&nbsp;g_dbpassword &amp;&nbsp;&quot;; Network=DBMSSOCN;&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; OBJdbConnection.Open strsql<br />
&nbsp; &nbsp; &nbsp; &nbsp; objCommand.ActiveConnectio<wbr />n = OBJdbConnection<br />
&nbsp; &nbsp; &nbsp; &nbsp; OBJdbConnection.CommandTim<wbr />eout = 0<br />
&nbsp; &nbsp; &nbsp; &nbsp; objCommand.CommandTimeout = 0
</div>
</div>


I have an MSAccess database that links tables to a SQL Server database via ODBC.  I would like to dynamically link those tables when the database is opened to avoid having the user needing the ODBC entry on their PC.  I can establish the link to the SQL Server database but from there, how do I LINK the tables.

This is how I establish the connection to the sql server database.  Can I use VBA code to link to the tables I need from here?
        strsql = "Driver={SQL server}; Server=" & g_dbserver & "; Port=1433; Option=0; Socket=; Stmt=; Database=" & g_db & "; Uid=" & g_dbuserid & "; Pwd=" & g_dbpassword & "; Network=DBMSSOCN;"
        OBJdbConnection.Open strsql
        objCommand.ActiveConnection = OBJdbConnection
        OBJdbConnection.CommandTimeout = 0
        objCommand.CommandTimeout = 0

Use VBA to link tables in SQL Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.