Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: Help to initialize the primary key in Access 2007

Results 1 to 2 of 2
Share This Thread →
  1. #1
    relk is offline Registered User
    Join Date
    Nov 2012
    Posts
    1
    Rep Power
    0

    Help to initialize the primary key in Access 2007

    Hi

    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?

    Thanks

  2. #2
    meratigoerr's Avatar
    meratigoerr is offline Contributing User
    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    58
    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.

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

Similar Threads

  1. MS Access Primary key error
    By threepins in forum Microsoft Access Help
    Replies: 2
    Last Post: September 24th, 2011, 03: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, 11:03 AM
  3. [MS ACCESS]Insert next autonumber into primary key
    By Jontron in forum .NET Development
    Replies: 5
    Last Post: April 19th, 2008, 09: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, 03: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, 02:30 AM

ASP Free Advertisers and Affiliates