Updating a linked table in access
In a previous tip we saw how easy it was to link to SQL Server tables from Microsoft Access.
As is the case with all systems, how does Access manage the changes?
What happens if you skipped assigning a primary key in Access and now wish to do so?
The process is identical to what I just demonstrated in regards to DDL changes to the SQL Server table.
Let's take a look at the process using a table that I am going to create in the Northwind database on my SQL Server instance called Sub Categories.