How to add ID 1 above table that starts with ID 2 ?

[Plomo]

Hey so my question is my title, how can I add a ID number of 1 above an existing table that alrdy exists and uses the ID of 2 to start?

Example:

ID:2 Name:Mich


ID:3 Name:Jim

What I want is to add a Number 1 above that Number 2 withought affecting the table.

Eaxmple:
ID:1 Name:John
ID:2 Name:Mich
ID:3 Name:Jim

I can always change the field or what not on ID but I cant change its order is there a way for this or should i just make a new table?

Sorry I never use access, so far so good though just learning stuff on the way.

Any help would be greatly appresiated thanks!

[Ryan]

If you want to make an autonumber field start at 1, you have 2 options:

1. Delete all data in the table, then compact database.

2. Delete column, then add it back in again. This way does not lose data. Unfortunately, you cannot guarentee what order the numbers will be assigned to existing records, Though maybe if you Sort them by the name you want?

In Addition, you have to remove all Relationships to the Field that gives the autonumber, and reassign them after.

You may want to have a close look at the relationships, so you can put them back.

Note: I noticed he said he cant effect the table, but as for as my book goes, it dont look like you can without alterting it.

[RuralGuy]

What I want is to add a Number 1 above that Number 2 withought affecting the table.

...you can't change the table?