Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2004
    Posts
    277

    Unanswered: need help quick.. restarting reference#..program goin live today

    ok.. i am trying to restart the reference autonumber at 45000. I did it once it worked using the append to table query.... but now it is starting at the last number i deleted instead of the number i want and goin to the next... HELP!!!

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Search the forums. There was a post about an undocumented reseed function last week sometime. I can't remember the thread title, but it was a handy trick.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Dec 2004
    Posts
    277
    thanks Teddy

  4. #4
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    After you delete your records and append your starting number record, perform a "compact and repair database". In the past, that is how I got the autonumber to reset. However that was Access 2K and prior versions.

    TD

Posting Permissions

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