Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2013
    Location
    Home
    Posts
    3

    Unanswered: Auto Primary Key until manually entered in field

    Is it possible for me to have a data base with the primary key set as an Auto-Number BUT I can go back into the database and then change that number manually?

    Im creating a simple database of grocery items, and I want to make use of the barcodes on them, typing in the numbers will be a bit too much work for me, so i will be buying a barcode reader in the near future.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    No, you can't edit the value in an Autonumber column in Access.
    Have a nice day!

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    its either OR, but NOT BOTH.

    if it helps an autonumber column should have no meaning outside the system itself. users should NOT be using an autonumber column, say, as a replacement for an invoice number, GRN, or anything else where the number has a significant meaning.
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •