Results 1 to 3 of 3
  1. #1
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Autonumbers changing (2003 (2000 fileformat))

    I have a database for an auctioneer. The Auctions table has an autonumber Primary Key.

    Auction 3 was a dummy one, and so it was deleted. Auction 4 was a real one.

    The auctioneer has a number of permanent bidders, who are automatically registered for any new auction. When we created auction 4, these people were registered, but when he ran the auction they weren't recognised as bidders.

    When I looked into it, I found that auction 4 had been renumbered to auction 3, and that these people were still registered for auction 4. (I had contributed to the problem because I had 'temporarily' turned off referential integrity checking and forgotten to turn it back on .)

    I have never had a problem with autonumbers changing before, and it is worrying. Has anyone else encountered it?
    Regards
    John



  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Autonumbers changing (2003 (2000 fileformat))

    With 2003 you almost certainly have SP8 of Jet, and it supposedly will reset the next autonumber when you do a compact, but that should not change existing values. In fact a user should not be able in general to change that field either, though you can use an append query to set specific autonumber values initially. Has anyone else seen behavior like this in 2003 <img src=/S/question.gif border=0 alt=question width=15 height=15> <img src=/S/question.gif border=0 alt=question width=15 height=15> <img src=/S/question.gif border=0 alt=question width=15 height=15>
    Wendell

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Autonumbers changing (2003 (2000 fileformat))

    Wendell, I have Access 2002 with Jet 4.0 SP-8, and that Jet version still has the problem that autonumbers do not get reset after a compact and repair, but I have never seen an existing autonumber change under SP-8.

Posting Permissions

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