Renumbering

[Guest]

Hello,

I am database learner. I found some problem in renumbering.

For example:

Autonumber Name Father's Name Mothers name
1 X Y Z
2 A B C
3 L M N
My problem is when I delete Autonumber 1. I see that

Autonumber Name Father's Name Mothers name
2 A B C
3 L M N

that means database table started begining with 2.

How can I renumber my autonumber (1, 2, 3, etc.)

Sharif

 

[Stefan B Rusynko]

Not possible w/ an autonumber field
- the numbers will never remain contiguous if you delete any records at any time
(the DB will always consider that # used and never reuse it)

If you need to do it 1 time (say to start fresh) you need to open the DB in Access and delete the autonumber field
- then compact the DB and add the autonumber field a new indexed autonumber field

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hello,
|
| I am database learner. I found some problem in renumbering.
|
| For example:
|
| Autonumber Name Father's Name Mothers name
| 1 X Y Z
| 2 A B C
| 3 L M N
| My problem is when I delete Autonumber 1. I see that
|
| Autonumber Name Father's Name Mothers name
| 2 A B C
| 3 L M N
|
| that means database table started begining with 2.
|
| How can I renumber my autonumber (1, 2, 3, etc.)
|
| Sharif