1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Nov 2012
    Rep Power

    Help to initialize the primary key in Access 2007


    I need help to initialize the primary key in Access 2007.
    At the moment I have several keys which are defined as AutoNumber some of them have the value 608 some have 127.
    I want all the keys to start from value=1.
    How should I do it?

    The second question is - for some reason some the values in the tables do not appear in the form.
    For example I have entered 3 records through the main form and I can see all the records in the different tables BUT when I go back (and I did save) to the orginial form I don't
    see all the previous records. I see only 2 out of 3. How come there's no synchronization between the form and the table?
    What do I do wrong?

  2. #2
  3. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Jun 2011
    South Jersey
    Rep Power
    1. to restart an auto number at 1, compact and repair the database. the auto number will reset back to the lowest available number. (1 only if there are no records in table.)

    2. your data is most likely not showing up because of the way your record source is constructed. because you mention multiple tables there must be a query as the record source. the relationships are most likely one to one. which means if data is missing from one table you records will not be displayed. change the relationship in your query and the records should show up.

Similar Threads

  1. MS Access Primary key error
    By threepins in forum Microsoft Access Help
    Replies: 2
    Last Post: September 24th, 2011, 04:09 PM
  2. Access 2003 sql statement not working in Access 2007
    By whiskers1978 in forum Microsoft Access Help
    Replies: 1
    Last Post: January 5th, 2009, 12:03 PM
  3. [MS ACCESS]Insert next autonumber into primary key
    By Jontron in forum .NET Development
    Replies: 5
    Last Post: April 19th, 2008, 10:40 AM
  4. Getting latest Primary Key ID from a table in Access DB
    By ikiloh in forum ASP Development
    Replies: 4
    Last Post: August 16th, 2005, 04:04 AM
  5. how to insert primary key field into access using asp
    By Steve Schofield in forum SQL Development
    Replies: 1
    Last Post: November 7th, 2000, 03:30 AM

IMN logo majestic logo threadwatch logo seochat tools logo