<div>
mahopman<br />
&nbsp; &nbsp; &nbsp; &nbsp; This works but I get an error messageindicating SQL Server ODBC Connection timed out. Possibly the SQK Server Express 2005 is not set up to allow external ODBC Connections. I will write another question to handle this problem
</div>


mahopman
        This works but I get an error messageindicating SQL Server ODBC Connection timed out. Possibly the SQK Server Express 2005 is not set up to allow external ODBC Connections. I will write another question to handle this problem

<div>
<div class="content wysiwyg-content">
I am using SQL Server 2005 Express and i wan to connect my MS accesss font end to a database I have created in SQL Server. I know how to set up ODBC connections but where I am having difficulty is pointing to where SQL SERVER Express has the actual database with in its system.<br />
<br />
How can I find the database I created? Where is it usually kept on my gard drive?<br />
<br />
Thanks in advance for your assistance.<br />
<br />
LAD
</div>
</div>


I am using SQL Server 2005 Express and i wan to connect my MS accesss font end to a database I have created in SQL Server. I know how to set up ODBC connections but where I am having difficulty is pointing to where SQL SERVER Express has the actual database with in its system.

How can I find the database I created? Where is it usually kept on my gard drive?

Thanks in advance for your assistance.

LAD

SQL Server 2005 - Connecting MS Access through ODBC

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.