Results 1 to 7 of 7

Thread: Autonumbering

  1. #1
    shoftware
    Guest

    Autonumbering

    I'm currently having a few problems with an Autonumber field. Things are fine until I compact the database, then it resets back to 0. This is betting to be quite a problem because the database is expanding rapidly !!!
    Anyone got a fix ?? Apart from resetting the autonumber field every time ??? <img src=/S/help.gif border=0 alt=help width=23 height=15>

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Autonumbering

    Are you deleting all the records in the table? And, what version of Access are you using? If A2000, make sure you have the SR-1 update.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    shoftware
    Guest

    Re: Autonumbering

    Hi Mark

    Version is A97
    The Database if a donation logging system for a charity.
    Whats happening is the donations are being entered into a table with the Autonumber field, when the "Day" is complete they are appended to the main Donations table and the "Day" table cleared out.

  4. #4
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Autonumbering

    ...and then you're doing a nightly repair and compact on the db, right?
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  5. #5
    shoftware
    Guest

    Re: Autonumbering

    Yes.... but they are comapcting weekly..

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Autonumbering

    Yes, if you have an empty table containing an autonumber field, then the autonumber will be reset when you compact the database (that's occasionally a useful feature).

    Also, since you mention tracking donations, BEWARE of using autonumbers if that field is to be in any way "official" (e.g. as an identifier for a tax receipt). If you delete a record you'll leave a gap in the numbering which could concern anyone looking at your records (i.e. "What happened to receipt 1534?")

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Autonumbering

    Q #1: Why is it necessary to have that separate daily table?

    Q #2: Is it necessary to carry-over the same ID number from the daily file to the main file when it gets posted there? (that is, why not have an autonumber field there?)
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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