Results 1 to 3 of 3

Thread: Auto number in access database - Urgent

  1. Jan 5th, 2000, 06:51 PM #1
    Caro
    Caro is offline

    Thread Starter
    Addicted Member
    Join Date
    May 1999
    Location
    Littlehampton, W Sussex GB
    Posts
    203

    Post

    Does anyone know how I can change the autonumber value on a table when it has data in it - the last number is 9998 but the next one is coming up as 12924 and I want it to be 9999. Any ideas?
    Reply With Quote Reply With Quote
  2. Jan 6th, 2000, 01:07 AM #2
    Clunietp
    Clunietp is offline
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844

    Post

    an AutoNumber is called an Autonumber because it's population is automatic. For some reason, MS Access does not reset it's auto number counter after an update was cancelled or records deleted.
    Reply With Quote Reply With Quote
  3. Jan 6th, 2000, 12:43 PM #3
    Guest

    Post

    Maybe you can cut the data of 12xxx, and then "add a new record" and paste it into it.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width