+ Reply to Thread
Results 1 to 2 of 2

autonumber in access not starting at 1

  1. #1
    Registered User
    Join Date
    09-07-2011
    Location
    vizag
    MS-Off Ver
    Excel 2007
    Posts
    46

    Thumbs up autonumber in access not starting at 1

    I have Created a form and 1st field SL_NO given as Auto number it's works fine but everyday i have delete old records and enter new records in that form...my problem is it's always starts with after old record number.

    Ex : yesterday i had enter 50 records and today i have deleted those 50 records and started my work but it's continuing with 51 only....Please help me......

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,461

    Re: autonumber in access not starting at 1

    First off, what difference does it make what the number is? If its an autonumber, it probably is use only as a unique record identifier.

    Now having said that, if you would like it to start over from 1, then after you delete your records, then you will need to run a compact and repair. Access, will continue to number sequentially from the last number used in an autonumber situation unless you take this step.

    Alan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1