November 22nd, 2012, 07:45 AM
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?
November 22nd, 2012, 01:08 PM
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.