By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,262 Members | 1,467 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,262 IT Pros & Developers. It's quick & easy.

reseting autonumber in MS Access 2003

P: n/a
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

Apr 25 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Apr 25 '07 #2

P: n/a
On Apr 25, 10:26 am, lamk...@gmail.com 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

Apr 26 '07 #3

P: n/a
"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
Apr 26 '07 #4

P: n/a
On Apr 27, 5:44 am, "Larry Linson" <boun...@localhost.notwrote:
"bubbles" <bubbles....@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

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

Apr 27 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.