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

D

dejanc

Registered User.

Local time

Today, 04:37

Joined

Aug 4, 2009

Messages

45

• Dec 17, 2015

• #1

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...

 

Attachments

• 
  Capture.PNG

  13.3 KB · Views: 183

Minty

AWF VIP

Local time

Today, 12:37

Joined

Jul 26, 2013

Messages

10,367

• Dec 17, 2015

• #2

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.

 

D

dejanc

Registered User.

Local time

Today, 04:37

Joined

Aug 4, 2009

Messages

45

• Dec 17, 2015

• #3

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