Updating tables in access 2016
Important To link access tables with an Azure database, you need SQL Server Native Client(SNAC) version 10.5 or above.
You can obtain the latest version of SNAC from Microsoft® SQL Server® 2008 R2 Feature Pack.
SQL Server Migration Assistant (SSMA) for Access backs up the original Access table and creates a linked table.
Note that you may update data in an Access table, but you cannot update data in linked table.Cause: After migrating data and linking tables, the user cannot modify the schema of a table in Access.Resolution: Modify the table schema by using SQL Server Management Studio, and then update the link in Access.For example, if your Access table is linked to Excel spreadsheet, you cannot update any data in the spreadsheet from Access.Suppose we have created a table called employee_tbl, now we want to update David’s salary to 11000.