Scenario: You have a SQL Server database and you edit that data using Access. You make a schema change to the SQL Server table and you want that change to be reflected in Access. It’s easy, yet unintuitive, so I wrote this post to help you out.
1. Make the change to your SQL Server Database Table.
2. Open Access, got to External Data –> Linked Table Manager
3. Select the table that you want to update and click OK
That’s all. Simple, yet I expected an “Update” button of some sort.