Autonumber

[kingofkabul@gmail.com]

Hi all,

I want to delete my records in the table and start from the beginning,
but when i do it the autonumber field doesn't start from one, however,
it is numbered after the last inserted record.

Could you please write how can i make the autonmumber field start from
1?

tanx n advance,

Naweed

[Jens Schilling]

Re: Autonumber

Hi,

I want to delete my records in the table and start from the beginning,
but when i do it the autonumber field doesn't start from one, however,
it is numbered after the last inserted record.

Take a look at this :

http://www.mvps.org/access/general/gen0006.htm

Regards
Jens

[David Harlowe]

Re: Autonumber

The easiest way is to create a new table as follows:

Right click the empty table and select Copy
Right click on some open space and select Paste
Enter a new table name and select the Structure Only paste option

This process will keep then same data structure and reset the autonumber
field to 1.

David

<kingofkabul@gm ail.comwrote in message
news:1181715473 .883211.150130@ e26g2000pro.goo glegroups.com.. .

Hi all,
>
I want to delete my records in the table and start from the beginning,
but when i do it the autonumber field doesn't start from one, however,
it is numbered after the last inserted record.
>
Could you please write how can i make the autonmumber field start from
1?
>
tanx n advance,
>
Naweed
>

[kingofkabul@gmail.com]

Re: Autonumber

On Jun 13, 10:47 am, "David Harlowe" <david.harl...@ nomail.comwrote :

The easiest way is to create a new table as follows:
>
Right click the empty table and select Copy
Right click on some open space and select Paste
Enter a new table name and select the Structure Only paste option
>
This process will keep then same data structure and reset the autonumber
field to 1.
>
David
>
<kingofka...@gm ail.comwrote in message
>
news:1181715473 .883211.150130@ e26g2000pro.goo glegroups.com.. .
>
>
>

Hi all,

>

I want to delete my records in the table and start from the beginning,
but when i do it the autonumber field doesn't start from one, however,
it is numbered after the last inserted record.

>

Could you please write how can i make the autonmumber field start from
1?

>

tanx n advance,

>

Naweed- Hide quoted text -

>
- Show quoted text -

yea,
but the new table won't have the old table's dependencies and
relationsships. I have to assign all the relationship for the table
again.

[Wayne Gillespie]

Re: Autonumber

On Tue, 12 Jun 2007 23:17:53 -0700, kingofkabul@gma il.com wrote:

>Hi all,
>
>I want to delete my records in the table and start from the beginning,
>but when i do it the autonumber field doesn't start from one, however,
>it is numbered after the last inserted record.
>
>Could you please write how can i make the autonmumber field start from
>1?
>
>tanx n advance,
>
>Naweed

Compact the database after you have deleted the records and before the first
record is added to the empty table.

(If the table is linked, compact the database which contains the table)

Wayne Gillespie
Gosford NSW Australia