Results 1 to 3 of 3

Thread: Access: Getting 0 as first num in AutoNumber field

  1. Jun 10th, 2003, 11:12 AM #1
    PaddyIrish
    PaddyIrish is offline

    Thread Starter
    New Member
    Join Date
    May 2003
    Posts
    12

    Access: Getting 0 as first num in AutoNumber field

    Hi,

    I know this isn't strictly a VB question but I am writing a program in VB which interacts with an MsAccess DB.
    My problem is that I have an Id field which is of type AutoNumber. No matter what I've tried, Access doesnt seem to like the number 0 in its autonumber fields. Does anyone know a way around this problem? I would be very grateful for any suggestions.

    Paddy
    Reply With Quote Reply With Quote
  2. Jun 10th, 2003, 01:20 PM #2
    ImpShial
    ImpShial is offline
    Lively Member
    Join Date
    Oct 2002
    Posts
    70
    Are you trying to manually enter a value into the AutoNumber field? Access won't allow you to manually enter a number into the autonumber field.

    And it ALWAYS starts with 1. Never 0.
    Reply With Quote Reply With Quote
  3. Jun 11th, 2003, 03:54 AM #3
    PaddyIrish
    PaddyIrish is offline

    Thread Starter
    New Member
    Join Date
    May 2003
    Posts
    12
    Yea thats what I figured. You can append from another table and get your autonumber to start at any positive number you like, but if you try getting it to start with a negative number the next number always jumps to 1 (skipping 0 completely). Its a pity because my user is insisting on using 0 as an Id number and it looks like it cant be done in access.

    thanks anyway, Paddy
    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