reseting autonumber in MS Access 2003

[lamkelf]

Hi all,

I have found solution for previous Access versions (i.e. compacting
database) but it doesn't work with the 2003 version. Can someone
point me to a website or give me some hints. Thanks!!!!!!

KL

[Allen Browne]

Compacting should work if all data has been removed from the table.
If it doesn't you may need to update your JET 4:
http://support.microsoft.com/kb/239114

You can reset the Seed of the AutoNumber programmatically:
http://allenbrowne.com/func-ADOX.html#GetSeedADOX

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<la*****@gmail.comwrote in message
news:11**********************@r3g2000prh.googlegro ups.com...

Hi all,

I have found solution for previous Access versions (i.e. compacting
database) but it doesn't work with the 2003 version. Can someone
point me to a website or give me some hints. Thanks!!!!!!

KL

[bubbles]

On Apr 25, 10:26 am, [e-mail] wrote:

Hi all,

I have found solution for previous Access versions (i.e. compacting
database) but it doesn't work with the 2003 version. Can someone
point me to a website or give me some hints. Thanks!!!!!!

KL

1. Delete the autonumber column
2. Compact the database.
3. Create a new autonumber column.

HTH
Bubbles

[Larry Linson]

"bubbles" <bu*********@hotmail.comwrote

1. Delete the autonumber column
2. Compact the database.
3. Create a new autonumber column.

That, unfortunately, works only if you are emptying the Table of Records, or
if you haven't used the autonumber column in relationships. At one time,
Compact and Repair, would reset the AutoNumber sequence to the next after
the highest-used number. Later versions would only reset to 0, if there
were no records in the Table.

But, if you eliminate the column, you "orphan" any Records in Related
Tables.

Larry Linson
Microsoft Access MVP

[bubbles]

On Apr 27, 5:44 am, "Larry Linson" <[e-mail]:

"bubbles" <[e-mail]

1. Delete the autonumber column
2. Compact the database.
3. Create a new autonumber column.

That, unfortunately, works only if you are emptying the Table of Records, or
if you haven't used the autonumber column in relationships. At one time,
Compact and Repair, would reset the AutoNumber sequence to the next after
the highest-used number. Later versions would only reset to 0, if there
were no records in the Table.

But, if you eliminate the column, you "orphan" any Records in Related
Tables.

Larry Linson
Microsoft Access MVP

You're right.
I had assumed that if he had wanted to reset the autonumber column,
then the table
would not be related to other tables.

Bubbles