Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Clear Database And Reset the AutoNumber

Discussion in 'Information Technology' started by jillian.calderon@gmail.com, Jul 28, 2006.

  1. jillian.calderon@gmail.com

    jillian.calderon@gmail.com
    Expand Collapse
    Guest

    Good Morning Everyone,

    I'm making a database and I'm playing with it using test data. When
    I want to put the actual data in, how do I reset the autonumber back to
    1? How do I tell the database to completely delete the fake records so
    the autonumber doesn't start at, o, 50?

    Thanks!
    Jillian
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Daily Meditation: Clear Mind Breaking News Mar 11, 2016
    General AISSF Urges SGPC to Clear its stand on Kumbh Mela Hard Talk Jan 12, 2013
    World UN links Iran to nuclear weapons Breaking News Nov 9, 2011
    Politics After Karachi: Is Pakistan’s nuclear arsenal safe? Breaking News May 23, 2011
    Can Somebody Clear My Confusion New to Sikhism Mar 7, 2011

  3. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    <jillian.calderon@gmail.com> wrote in message
    news:1153496099.798558.182050@75g2000cwc.googlegroups.com
    > Good Morning Everyone,
    >
    > I'm making a database and I'm playing with it using test data. When
    > I want to put the actual data in, how do I reset the autonumber back
    > to 1? How do I tell the database to completely delete the fake
    > records so the autonumber doesn't start at, o, 50?


    You can manually delete all the records and then compact the database,
    or you can run delete queries on all the tables and then compact the
    database.

    Or you could create a new database and import all the objects from the
    old database, but specify the option to import just the structure of the
    tables, not the structure and data. I wouldn't normally do it this way,
    though, because there are some things that don't get imported and have
    to be rebuilt manually -- references, for example, and database
    properties.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     
  4. jillian.calderon@gmail.com

    jillian.calderon@gmail.com
    Expand Collapse
    Guest

    I didn't even notice there was a way to compact the database.
    Thank you!!!
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    I suggest you may not want to use Autonumber for that use. Autonumbers are
    designed to provide unique numbers. It in not designed to provide numbers
    in order and for a number of reasons may not do so. As a result using them
    in any application where the user sees the numbers is likely to end up with
    confusion.

    There are other ways of providing the numbers you want depending on the
    particular application.


    --
    Joseph Meehan

    Dia duit
    <jillian.calderon@gmail.com> wrote in message
    news:1153496099.798558.182050@75g2000cwc.googlegroups.com...
    > Good Morning Everyone,
    >
    > I'm making a database and I'm playing with it using test data. When
    > I want to put the actual data in, how do I reset the autonumber back to
    > 1? How do I tell the database to completely delete the fake records so
    > the autonumber doesn't start at, o, 50?
    >
    > Thanks!
    > Jillian
    >
     
  6. jillian.calderon@gmail.com

    jillian.calderon@gmail.com
    Expand Collapse
    Guest

    I'm not sure why I care, but it could be that I'm OCD. This is in fact
    my first database, and that it'll contain well over 30,000 records made
    me want everthing to be clear. Thanks for clearing up the inanity of
    ordered autonumbers! They don't have to be in order. I was parinoid
    because on of my forms wouldn't let me add a record because "The
    changes you requested to the table were not successful because they
    would create duplicate values...". Oddly enough, the suggestion to
    compact the database eliminated the problem in addition to fixing my
    relations. I didn't really need them to be in order. I just thought
    access was taking up space with records that didn't exist.

    Jill
     
  7. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Compacting is good, but keep those autonumber hidden from users who
    don't understand that they are not in order, or choose to let Access use
    Random numbers so no one can figure it out. :)

    --
    Joseph Meehan

    Dia duit
    <jillian.calderon@gmail.com> wrote in message
    news:1153518282.858306.31790@b28g2000cwb.googlegroups.com...
    > I'm not sure why I care, but it could be that I'm OCD. This is in fact
    > my first database, and that it'll contain well over 30,000 records made
    > me want everthing to be clear. Thanks for clearing up the inanity of
    > ordered autonumbers! They don't have to be in order. I was parinoid
    > because on of my forms wouldn't let me add a record because "The
    > changes you requested to the table were not successful because they
    > would create duplicate values...". Oddly enough, the suggestion to
    > compact the database eliminated the problem in addition to fixing my
    > relations. I didn't really need them to be in order. I just thought
    > access was taking up space with records that didn't exist.
    >
    > Jill
    >
     
  8. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    By the way, I've seen your question in at least 3 separate newsgroups now.

    If you feel you need to post to more than one group (HINT: it's seldom
    necessary), please have the courtesy to cross-post (send the one message to
    all groups at once), rather than multi-post (send individual messages to
    each group). In this way, all responses to your post will be available
    together, regardless of what group the responder was in, and the rest of us
    won't have to read your post multiple times. (It also uses fewer server
    resources)

    I see you're using Google Groups. I'm not aware specifically of how to
    cross-post there, but in general you should be able to type the names of the
    various groups in the Newsgroup box, separating each newsgroup name with a
    semicolon.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    <jillian.calderon@gmail.com> wrote in message
    news:1153518282.858306.31790@b28g2000cwb.googlegroups.com...
    > I'm not sure why I care, but it could be that I'm OCD. This is in fact
    > my first database, and that it'll contain well over 30,000 records made
    > me want everthing to be clear. Thanks for clearing up the inanity of
    > ordered autonumbers! They don't have to be in order. I was parinoid
    > because on of my forms wouldn't let me add a record because "The
    > changes you requested to the table were not successful because they
    > would create duplicate values...". Oddly enough, the suggestion to
    > compact the database eliminated the problem in addition to fixing my
    > relations. I didn't really need them to be in order. I just thought
    > access was taking up space with records that didn't exist.
    >
    > Jill
    >
     

Share This Page