How to Update a Linked Table Schema in Access

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.

Jon

Share