<div>
and a good site BTW for getting the required connect strings for a data source is:<br />
<br />
www. connectionstrings.com<br />
<br />
Jim.
</div>


and a good site BTW for getting the required connect strings for a data source is:

www. connectionstrings.com

Jim.

<div>
Thanks Jim for the help. &nbsp;I did some research and came up with the following link<br />
<a href="http://support.microsoft.com/kb/892490" rel="ugc">http://support.microsoft.com/kb/892490</a><br />
<br />
It does the same thing as the link you posted. &nbsp;Both use the table def collection. &nbsp;BTW thanks for the link for connection strings
</div>


Thanks Jim for the help.  I did some research and came up with the following link
http://support.microsoft.com/kb/892490 [http://support.microsoft.com/kb/892490]

It does the same thing as the link you posted.  Both use the table def collection.  BTW thanks for the link for connection strings

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I'm trying to set up a dsn less odbc link to a table on an 2005 sql server from an access front end. &nbsp;The server uses Sql Server authentication. &nbsp;There are already several tables that are linked to the Access 2007 front end in this fashion. &nbsp;This is an application I just took over and the previous developer is not available. &nbsp;I'm trying to find out how the previous developer was created these dsn-less odbc connections to the backend.
</div>
</div>


Hello,

I'm trying to set up a dsn less odbc link to a table on an 2005 sql server from an access front end.  The server uses Sql Server authentication.  There are already several tables that are linked to the Access 2007 front end in this fashion.  This is an application I just took over and the previous developer is not available.  I'm trying to find out how the previous developer was created these dsn-less odbc connections to the backend.

How to set up a dsn less odbc link

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.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.