<div>
This answer lead me to the make table query which what I was looking for. Thanks.
</div>


This answer lead me to the make table query which what I was looking for. Thanks.

<div>
You're welcome. &nbsp;Glad to help.<br />
<br />
Happy Computing!<br />
<br />
Nelson
</div>


You're welcome.  Glad to help.

Happy Computing!

Nelson

<div>
<div class="content wysiwyg-content">
I have a several tables linked to a MS SQL Server. How do I synchronize a MS SQL linked table and a local table? &nbsp;I want to do this so when I am not going the have an internet connect I will still be able to view the data. I will not be editing or entering data into the local table. 
</div>
</div>


I have a several tables linked to a MS SQL Server. How do I synchronize a MS SQL linked table and a local table?  I want to do this so when I am not going the have an internet connect I will still be able to view the data. I will not be editing or entering data into the local table. 

Synchronize  MS SQL linked table and a local table

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 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.