Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Feb 2003
    Thanked 0 Times in 0 Posts

    Adding a new AutoNumber field (2000)

    I have received an access db with a table containing 30000+ records and NO primary key.

    I want to add an AUTONUMBER field, making it the pk.

    I tried creating a new table with just an autonumber field. Then I thoulght I could join the 2 tables using a Make Table Query.
    Am I on the right track? haven't quite got it. Any ideas?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Adding a new AutoNumber field (2000)

    You can open the existing table, and add an AutoNumber field. It will be populated automatically. No need to use two tables (unless you want to split the existing table for normalization purposes.)

Posting Permissions

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