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

dejandejanovic
dejandejanovic used Ask the Experts™
on
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...
Capture.PNG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software Architect
Commented:
As per my knowledge, in linking normally primary key association is the main thing, make sure you have a primary key defined on your linked table in SQL server and also in Access when you linked the SQL Table. Once you do this, you insert values into the Access with the linked table name and it would reflect the values.
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
You may also need a field in the SQL Server table of data type Timestamp and include that as well.

This is for the ODBC to keep track of the records and if they have been changed.

/gustav

Author

Commented:
Yeap. Both correct. I have added primary key on field, and timestamp, and works perfect. Changes are successful sync in both way.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial