Results 1 to 2 of 2
  1. #1
    mjackman is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2012
    Posts
    1

    Primary key default value

    Hello all =)



    I would like to create a DB of Customer returns and so would like the Primary Key to be the individual number for each returned product. However, as the returns system is already in place (on a different DB system), I would like to start the records at 20000 (not #1 as dictated by the primary key), so the question is, can i change the value of the first record to Number 20000 in the primary key field and have it auto-increment with every record, as I cant seem to do this at the moment? Many thanks in advance!

    Best regards
    Mjackman

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    That is NOT a good strategy. You can start an auto number from a value other than 0, but you can not depend on Access to provide sequential numbers. Autonumbers in Access are meant only to be UNiQUE--NOT SEQUENTIAL. If, for any reason you removed/quit assignment etc, an autonumber could lose any sequencing you might "wrongly" depend on.

    For Returns, you have a Date, a Customer, some Order Number etc, so you can match records based on those field values, and still use a separate autonumber as a key in your system.

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

Similar Threads

  1. Primary key
    By Sara_IT in forum Access
    Replies: 2
    Last Post: 11-25-2011, 02:46 PM
  2. Primary Key
    By DukeBlue in forum Access
    Replies: 18
    Last Post: 09-23-2011, 05:23 PM
  3. alphanumeric primary key
    By slimjen in forum Database Design
    Replies: 4
    Last Post: 09-18-2011, 10:20 PM
  4. Primary Key Help
    By phoenix13 in forum Access
    Replies: 4
    Last Post: 07-30-2009, 12:36 PM
  5. about the primary key!
    By Yuesko in forum Access
    Replies: 1
    Last Post: 05-29-2009, 04:20 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