Results 1 to 4 of 4

Thread: Reset AutoNumber In access

  1. Jul 25th, 2001, 03:57 PM #1
    shragel
    shragel is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2000
    Location
    Brooklyn NY USA
    Posts
    1,258

    Reset AutoNumber In access

    I know this has already been asked here.
    And I also know that MSDN says some wierd way of resettint the AutoNumber it should restart by 1. And I know that if there is No Records in the table it will reset by compacting.
    How Could I reset it even if I have 1 or 2 records in the tabe?
    Reply With Quote Reply With Quote
  2. Jul 25th, 2001, 03:59 PM #2
    peet
    peet is offline
    -= B u g S l a y e r =- peet's Avatar
    Join Date
    Aug 2000
    Posts
    9,629
    I don't think u can ...
    -= a peet post =-
    Reply With Quote Reply With Quote
  3. Jul 25th, 2001, 07:42 PM #3
    shragel
    shragel is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2000
    Location
    Brooklyn NY USA
    Posts
    1,258
    It must be a way.
    How does the Jet engine store what has to be the next Number, maybe I could change that.
    Reply With Quote Reply With Quote
  4. Jul 25th, 2001, 07:44 PM #4
    Nucleus
    Nucleus is offline
    Registered User Nucleus's Avatar
    Join Date
    Apr 2001
    Location
    So that's what you are up to ;)
    Posts
    2,530
    Well you could delete the realtionships based on the autonumber field, then delete the field. Add a new field as autonumber, rename it the same name as the original autonumber field. Finally recreate the relationships.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width