To have autonumber start from a certain number

[Frank Situmorang]

Hello,

I am creating a database to replace our excel to record our church membership.

Our last number is 580 on membership table, and on address table is 193.

During the construction I did not realize that if we delete autonumber for
the testing data, it will not continue with the next number of 581... There
are 5 records testing that I deleted and when I see now it shows 586.

I have finished testing, I want it to show the next number is 581. The same
problem with the Address autonumber

Please help what should I do.

 

[Allen Browne]

In some versions of Access, all you have to do is compact/repair the
database.

If is possible to programmatically set the Seed if you need to. Here's an
example:
http://allenbrowne.com/func-ADOX.html#ResetSeed

 

[Frank Situmorang]

Allen,

I have tried to compat/repair but the figure of the autonumber sitll shows
586. How can we change it. should we delete first and then we compat and
repair?

While doing seed is it too risky to do it?, will jepoardize all the links?,
I am not quite understand how to do it.

Thanks for in advance for more explanations

 

[Allen Browne]

Try the code. Back up first if you are worried.

You will need the ADOX library reference.