Hello, I have a DB with 17 tables and most of the the Primary Key for each table is alphanumeric. I want to change all the Primary Keys in each table to an autonumber. If all my tables have an autonumber as a Primary Key would this cause a problem with creating queries or forms? I am a novice at Access so I am not sure what is best used for Primary Keys.
Primary Key
- Thread starter Jeanette
- Start date
- Local time
- Today, 07:24
- Joined
- Feb 19, 2002
- Messages
- 47,134
I do not believe that the surrogate key is the only option for primary keys. The people who recommend that, talk in terms of speed, storage, etc. However, when your db is never going to contain millions of rows, you are unlikely to achieve any real performance enhancement and unless your text key is excessively large you won't see much in the way of storage reduction. Why do you feel it necessary to redo your primary keys?
Thanks for your quick response. The reason I was thinking of changing the primary keys is so that it would be easier for the data entry person to not have to enter an unique ID for each new record added. As it would cause to many problems to change all the primary keys, I decided not to.
Similar threads
