-
primary key
I have a VB application using an Access database ( converted from a dos based prog.) I need to use .Resync on 2 of the tables in the database but cannot as neither of the tables have a primary key. If I add 1 or more primary keys to the tables, will my app. still work ? or will it create problems ?
Troglodyte :wave:
-
The Primary Key insures uniqueness between rows and when dealing with relational database such as Access is a good idea. That being said, adding a primary key should not cause your application to stop working.