Results 1 to 2 of 2

Thread: Change the auto-increment in Access

  1. Nov 1st, 2002, 11:20 AM #1
    j_jewell
    j_jewell is offline

    Thread Starter
    Hyperactive Member
    Join Date
    May 2002
    Location
    Omaha, NE
    Posts
    263

    Change the auto-increment in Access

    Hi all,

    Hopefully this is an easy question for one of you gurus. I have an auto-increment field, and I would like the start value to be different than 1 (Because it will later be migrated to SQL Server, along with another database collecting the same data, and we don't want to end up with duplicate keys). Any thoughts or assistance are appreciated.

    Thanks in advance for the help!
    Reply With Quote Reply With Quote
  2. Nov 1st, 2002, 11:42 AM #2
    D12Bit
    D12Bit is offline
    Hyperactive Member D12Bit's Avatar
    Join Date
    Oct 2000
    Location
    Guatemala
    Posts
    373
    Not a biggie...just manually change the number of the last record...add one more if you like and then erase the contents...
    and you'll get a new start number...higher that 1...
    "Who Dares Wins" - "Quien se Arriesga Gana"
    Mail me at:
    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