Problem with linking tables

[Ritz]

I have a 2016 version of Access and the 2014 version of SQL Server.

Everything is fully "connected' via ODBC, but when I try to utilize the original tables to use a form, it doesn't update on SQL.

Do the tables only update on SQL server if the connection is from a table that I imported from the ODBC, or can I link the table from the ODBC, with the original table.

The only reason why I'm keeping the original tables is because there's a lot of data associated with them.

 

[Minty]

I'm not sure I understand your set up.
Are you saying you have a table say called tb_Clients in Access and a table called dbo_tb_Clients in SQL server and you are trying to update both at the same time?

Normally you would simply upload your whole original Access table to SQL server and remove the original table from the Access system.