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

  3. dkimbrell

    Dan Dungan Guest

    Is there something that stops you from using the primary key assigned
    by SQL server?
    Dan Dungan, Apr 4, 2012
    1. Advertisements

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.