How to drop a field with primary key
I am using VB6 code to manage an Access database. I want to drop a field with primary key and then add another primary key to another field. I found some web pages mentioning about dropping contraint before dropping the field. However, the database, table, fields and primary key was created in Access so I do not know what its contraint name is. I tried db.Execute "ALTER TABLE myTable DROP CONSTRAINT ID" but got an error of "Check constraint ID doesn't exist".
What can I do?