Why won't Access assign a Primary Key ID to my linked SQL Table?

Discussion in 'Access Table Design' started by dkimbrell, Mar 9, 2012.

  1. dkimbrell

    dkimbrell Guest

    In Access (2008), when I have a local table with a Primary Key and I
    add a new record in the table view, Access automatically gives the new
    record a primary key value.

    But when I open a table linked to my backend SQL Server that also has
    a primary key (identified in SQL Server), Access will not give it an
    ID and so I cannot add a record there.

    How do I fix this?
     
    dkimbrell, Mar 9, 2012
    #1
    1. Advertisements

  2. dkimbrell

    dkimbrell Guest

    I should also specify, that when I try to add records to a local
    Access table, the Primary Key is set to Autonumber. I don't see that
    as an option in SQL Server. I'm sure that's the reason, but how do I
    work around that so that I can add records in a table view in Access?
     
    dkimbrell, Mar 9, 2012
    #2
    1. Advertisements

  3. dkimbrell

    Dan Dungan Guest

    Is there something that stops you from using the primary key assigned
    by SQL server?

    On Mar 9, 8:17 am, dkimbrell <> wrote:
    > I should also specify, that when I try to add records to a local
    > Access table, the Primary Key is set to Autonumber.  I don't see that
    > as an option in SQL Server.  I'm sure that's the reason, but how do I
    > work around that so that I can add records in a table view in Access?
     
    Dan Dungan, Apr 4, 2012
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Roe
    Replies:
    1
    Views:
    109
  2. HENRY ONYEAGBAKO
    Replies:
    2
    Views:
    214
    Steve Schapel
    Feb 1, 2004
  3. HDW
    Replies:
    3
    Views:
    265
    Allen Browne
    Oct 16, 2004
  4. The parawon

    Is there a way to make a primary key in a linked table?

    The parawon, Feb 25, 2005, in forum: Access Table Design
    Replies:
    1
    Views:
    81
    John Vinson
    Feb 25, 2005
  5. Stephen

    Access Help: Primary key and SQL statement

    Stephen, Jan 6, 2006, in forum: Access Table Design
    Replies:
    1
    Views:
    76
  6. fizban33
    Replies:
    8
    Views:
    129
    BruceM
    Jun 19, 2006
  7. Alan

    ODBC linked table - primary key

    Alan, May 17, 2007, in forum: Access Table Design
    Replies:
    11
    Views:
    216
    Rick Brandt
    Jul 31, 2010
  8. boooney
    Replies:
    3
    Views:
    377
    John W. Vinson
    Apr 15, 2010
Loading...