Add new records in an Access linked table RRS feed

  • Question

  • I have an SQL server setup, allowing me every permission under the sun I think.  If I use Access' migrate data feature, I end up with basically the same tables and functionality as I had when they were access tables.  If I use Import, OBDC database to create a linked table in Access, I end up with the same table, except I can't add or modify records in linked table view. Strangely, I can add records using an append query, though this is far more inconvenient than simply adding a new record in datasheet mode.  Can anyone help me out, I can't seem to locate which settings will enable these features.

    Tuesday, December 13, 2011 4:55 AM

All replies

  • So you have SQL Server with linked server to Access and cannot add rows to access table?
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, December 13, 2011 6:34 AM
  • Yes.  Tables I manually link I cannot modify or add new records, but tables that exist in Access, which I "migrate" over to the same SQL server I can modify and add new records.
    Tuesday, December 13, 2011 1:29 PM
  • These tables you cannot update, do they have a primary key? If not, that is the issue.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    • Proposed as answer by Iric Wen Thursday, December 22, 2011 1:05 AM
    Tuesday, December 13, 2011 10:54 PM