CONTSRAINT PRIMARY KEY

[Steve]

I am working with a table that was created
programmatically. The name of the PRIMARY KEY was
automatically generated by Access. How can I find out
what the PRIMARY KEY name is?

 

[Douglas J. Steele]

Using DAO, you can determine the field(s) that makes up PrimaryKey (don't
forget that a primary key may be more than one field) using code such as:

Dim dbCurr As DAO.Database
Dim tdfCurr As DAO.TableDef
Dim idxCurr As DAO.Index
Dim fldCurr As DAO.Field
Dim strTableName As String

strTableName = "MyTable"
Set dbCurr = CurrentDb()
Set tdfCurr = dbCurr.TableDefs(strTableName)
Set idxCurr = tdfCurr.Indexes("PrimaryKey")
For Each fldCurr In idxCurr.Fields
Debug.Print fldCurr.Name
Next fldCurr

 

[Steve]

Thank you! Do you know how to get the same information
using MFC's CRecordSet?

 

[Douglas J. Steele]

Sorry, no I don't.