Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Autonumber (Access 97)

    Why is it not a good idea to use Autonumber as a Primary Key?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Autonumber (Access 97)

    Huh?

    It is an excellent idea to use an AutoNumber field as primary key. One advantage is that it can't be modified by the user, another that is is guaranteed to be unique (there were some issues with this in early versions of Access 2000, I think, but not in Access 97 as far as I know).

    One thing to keep in mind is that an AutoNumber field is essentially a meaningless number. Preferably, it should be hidden from the end user. For the developer, it is a convenient way to create a unique identifier for a record, and as such a natural candidate to be the primary key.

  3. #3
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Autonumber (Access 97)

    Thanks

Posting Permissions

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