<div>
<div class="content wysiwyg-content">
I am trying to update a MS Access table based on a table in a MS SQL Server:<br />
<br />
Example: Persons 01 to 10 and Rooms A to J<br />
<br />
The Table on the server gets updated periodically and I want my Access table to reflect that.<br />
<br />
Example: &nbsp;I have an Access table with Rooms A-J in a column, when Person 05 &nbsp;moves from Room A to Room E; I want my table to reflect that.<br />
<br />
Is this possible? &nbsp;If so, what is the easiest way? &nbsp;Thanks.<br />
<br />

</div>
</div>


I am trying to update a MS Access table based on a table in a MS SQL Server:

Example: Persons 01 to 10 and Rooms A to J

The Table on the server gets updated periodically and I want my Access table to reflect that.

Example:  I have an Access table with Rooms A-J in a column, when Person 05  moves from Room A to Room E; I want my table to reflect that.

Is this possible?  If so, what is the easiest way?  Thanks.



Auto Update MS Access fields

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

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.