Community discussion forum

Back to discussion

Access AutoNumber Reset

Last post was 16 Oct 2008 at 01:56
Tags: United Kingdom
This is a comment thread discussing Access AutoNumber Reset
  • 9 years ago

    This thread is for discussions of Access AutoNumber Reset.

    Report abuse
  • Advertisement

    Simply the fastest line-level profiler for .NET ever

    “The low overhead means it has minimal impact on the execution of my program”
    Mark Everest, Development Team Leader, Renault F1 Team Ltd.

    Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

  • 5 years ago

    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!

    Report abuse
  • 3 years ago

    nice


    changed a line in your module code:


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

    Report abuse
  • 3 years ago

    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

    Report abuse
  • 3 years ago

    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.

    Report abuse
  • 3 years ago

    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.

    Report abuse
  • 1 year ago

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

    Dejan



    Report abuse
  • 1 year ago

    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.













    Report abuse
  • 1 year ago

    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

    Report abuse
  • 1 month ago

    Wow. Thanx. I hope this moves me over, and I will be able to make deep table clones with relations. If not, compacting and repairing is great step forward for Light DB Browser

    Report abuse

Post a reply

Enter your message below

Sign in or Join us (it's free).

Quick links

Recent activity

Languages

Web Development

Frameworks & Architecture

Other major sections