Insert/update values into linked table (linked from sql server via odbc connection)

[dejanc]

Hello,
I would like to found how to insert values into Ms Access linked table? Table linked from sql server, with odbc connection.

Thanks in advance for help...

 

[Minty]

Use an Insert Query, or write a SQL Insert statement in code.
They are mostly no different to use than normal Access tables.

But I would look at your data structure if you have Test1, test2 etc as fields. That is not a normalised structure.

 

[dejanc]

Thanks for reply. I have found that I was missing primary key field, and timestamp.