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?

Jeff

RE: DBEngine(0)(0).TableDefs("Tablename").Indexes(0).N ame

Loop through the .Indexes collection of the Tabledefs("Tablename") object to find the .Name property of the index with the .Primary property set to True.

~ Shaun