1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Access 2000

Discussion in 'Other PC Software' started by maxmangion, 2003/02/25.

Thread Status:
Not open for further replies.
  1. 2003/02/25
    maxmangion

    maxmangion Inactive Thread Starter

    Joined:
    2002/08/13
    Messages:
    252
    Likes Received:
    0
    When deleting a record in Access and that record contained an AutoNumber field, is there a way that when adding a new record, it will take it's AutoNumber.

    For example if I have 100 records and I deleted record no. 10; Now when I add the 101th record is it possible that the Autonumber will replace the no. 10 instead of writing 101.

    Thanks
     
    maxmangion,
    #1
  2. 2003/02/25
    JohnB Lifetime Subscription

    JohnB Well-Known Member

    Joined:
    2002/01/07
    Messages:
    856
    Likes Received:
    11
    As far as I know you cannot re-use or update auto numbers in Access records. This is an exerpt from Access help:

    "A unique sequential (incremented by 1) number or random number assigned by Microsoft Access whenever a new record is added to a table. AutoNumber fields can't be updated. For more information, see the NewValues property topic. "
     
    JohnB,
    #2


  3. to hide this advert.

Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...