Results 1 to 4 of 4
  1. #1
    dejanc is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Dec 2015
    Posts
    2

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

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

    hanks in advance for help...



    Click image for larger version. 

Name:	Capture.PNG 
Views:	8 
Size:	13.3 KB 
ID:	23075

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Have you tried adding records into the table via SSMS and then viewing the records in Access? Maybe it is a permissions issue with the User you used when connecting.

  3. #3
    dejanc is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Dec 2015
    Posts
    2
    Quote Originally Posted by ItsMe View Post
    Have you tried adding records into the table via SSMS and then viewing the records in Access? Maybe it is a permissions issue with the User you used when connecting.
    Thanks for reply. I have found missing things, which are primary key, and timestramp key in sql table. After creating that, I have just re-link table, and under access file was able to edit append, or edit records.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Good to hear. Thanks for posting your solution.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Linked Table ODBC connection
    By Tim@Syosset in forum SQL Server
    Replies: 5
    Last Post: 01-09-2015, 02:27 PM
  2. Replies: 8
    Last Post: 09-27-2012, 08:23 AM
  3. Replies: 0
    Last Post: 03-08-2012, 03:12 AM
  4. Replies: 1
    Last Post: 01-22-2011, 12:23 PM
  5. Linked tables and ODBC connection strings
    By cwcadm in forum Import/Export Data
    Replies: 7
    Last Post: 05-26-2009, 07:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums