<div>
thanks for the reply. I don't have the ability to setup any SQL Server instance in my environment, just curious. &nbsp;@Vitor, with my current setup how would I be able to create a linked server to an MS Access database? I don't need to work with forms, reports or code.
</div>


thanks for the reply. I don't have the ability to setup any SQL Server instance in my environment, just curious.  @Vitor, with my current setup how would I be able to create a linked server to an MS Access database? I don't need to work with forms, reports or code.

<div>
thanks for verifying, I thought that was the case - just wanted to make sure in case there was another way.
</div>


thanks for verifying, I thought that was the case - just wanted to make sure in case there was another way.

<div>
<div class="content wysiwyg-content">
I have SQL Server Management Studio installed (2008) on Windows 7. &nbsp;There is no database services installed only SSMS compact edition. &nbsp;My question is there a way to connect to a Microsoft Access database with this setup?<br />
Thanks for any feedback.
</div>
</div>


I have SQL Server Management Studio installed (2008) on Windows 7.  There is no database services installed only SSMS compact edition.  My question is there a way to connect to a Microsoft Access database with this setup?
Thanks for any feedback.

SSMS Access Database

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 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.