Primary Key

[Jeanette]

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.

 

[Mile-O]

Might you not find yourself having to reconsider foreign keys within your database too?

 

[Jeanette]

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.