This thread is for discussions of Access AutoNumber Reset.

Well Done Mike....just what I needed! Saves re-building the database...whcih was what I'd been told by 'the experts' at our place!

nice

changed a line in your module code:

sExt = Right$(sDestination, Len(sDestination) - InStrRev(sDestination, ".") + 1)

I have access database that use autonumber (starting from 1) , I have some number that is missing, how do I reset it?
Sorry, I am not a programmer, so I didn't understand where I should put the code .

Thank you very much
clee

The code is part of a Visual Basic project (VB6).  It uses an external ADO connection into Access in order to do the autonumber reset.  You can do the same thing inside of access by adding a reference to ADO in the Visual Basic editor, then editing the code to work inside an Access module.

I have been having the problem with autonumber reset for the past couple of months, and I am getting tired of having to delete the relationships, create a new table, copy the data etc... Can this reset program of your's work in Access 2003, or are there additional steps I am not completing?  I get the following error message "There has been a critical error! Error - 2147467259 Method '-' object '-' failed"

Thank you in advance for your assistance.

Thanks a lot!! This is a very useful application!! WELL DONE!

Dejan

I agree with the others that the little autonum reset application is very nice however I've been banging my head over trying to use it with a db that has a username and password.  It looks obvious but I can't seem to get it to work.
When I plug in 2 variables:
UserID = "Admin"
Password = "MYPASSWORD"
I get this error:
"Cannot start application. The workgroup information file is missing or opened exlusively by another user."
The database is not open at all so I don't understand what the problem is.
I am a newbie to this so I'm thinking that I must be making some silly mistake. I was hoping that you wouldn't mind pointing me in the right direction. What am I doing wrong?

PS ... if I disable the password in my db, your application works like a charm.
Thanks in advance.

Hi only new to access so I am not sure I am doing the right thing.

When I run this I point it to my Database & run it. It goes through everything and completes successfully. But I cannot see any changes.

All my autonumbers are still the same they have not been reset starting from one.

What am I doing wrong or have I got it wrong and this is not what its suppost to do.

Pls let me know.

Tks