Results 1 to 3 of 3
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020

    Auto Number Primary Key In new SQL Server Table

    Hello to all,

    Just created my first table in SQL Server, after a bit of trial and error, I have it created and then also linked it back to my access database.

    However with everything I have tried, compared it to other tables in SQL server to make sure the settings were the same, I cant seem to make the Primary Key field AutoNumber when it is in Access.

    What am I missing or doing wrong?

    Is this an access feature, do I need to change it to autonumber in access and then relink it back to SQL Server to make it work?

    Thanks for the help

  2. #2
    wvmitchell is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2020
    In SQL Server, the equivalent field type is Identity, most often it is an int. You have to create an identity column 'from scratch' meaning that you can't modify a column to have those properties.
    Last edited by wvmitchell; 04-24-2021 at 10:09 AM. Reason: add 'int' reference

  3. #3
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Kelowna, BC, Canada
    Have a look at one of your existing tables that has one in design view and expand the Identity Specification section:
    Click image for larger version. 

Name:	Capture.PNG 
Views:	11 
Size:	26.4 KB 
ID:	45080
    Vlad Cucinschi
    MS Access Developer

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

Similar Threads

  1. Replies: 4
    Last Post: 08-14-2020, 03:26 PM
  2. Replies: 3
    Last Post: 10-07-2018, 04:25 PM
  3. Replies: 3
    Last Post: 11-30-2016, 05:09 PM
  4. Replies: 3
    Last Post: 03-10-2016, 12:53 PM
  5. Primary Key Auto Number not available in Excel for import
    By justphilip2003 in forum Import/Export Data
    Replies: 1
    Last Post: 04-30-2013, 07:52 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