<div>
Is there some particular reason that you don't want to use a linked table and a bound form?
</div>


Is there some particular reason that you don't want to use a linked table and a bound form?

<div>
<div class="content wysiwyg-content">
I need to connect my Access 2010 form with SQL Server 2012 table ”tblMaster” &nbsp;seating in SQL Server database named “Production_db” .<br />
I would like to use ADO to connect and pull out some records from table” tblMaster”.<br />
For that reason I probably need to initiate reference Microsoft Active X Data Object control &nbsp;2.8 in MS Access reference settings <br />
I would like to have command button on form which I click and make connection to table in SQL Server database &nbsp;then select &nbsp;particular record &nbsp;from table and then display it on form fields.<br />
&nbsp;My PC is on company network.<br />
SQL Server database is seating on one company server named Prod_Serv &nbsp;that is on company network too.<br />
I need code that will be behind this command button.
</div>
</div>


I need to connect my Access 2010 form with SQL Server 2012 table ”tblMaster”  seating in SQL Server database named “Production_db” .
I would like to use ADO to connect and pull out some records from table” tblMaster”.
For that reason I probably need to initiate reference Microsoft Active X Data Object control  2.8 in MS Access reference settings 
I would like to have command button on form which I click and make connection to table in SQL Server database  then select  particular record  from table and then display it on form fields.
 My PC is on company network.
SQL Server database is seating on one company server named Prod_Serv  that is on company network too.
I need code that will be behind this command button.

MS access to 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.

Microsoft SQL Server 2008

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.