How to get the auto-increment column from a table of MS Access Database using ADO and C++?

Question

I have used the following way to determine if a column is auto-increment:

att = Rs1->Fields->GetItem((long)nIndex)->Attributes;
bAutoIncrement = att & adFldRowID;

But it doesn't work at all. Do anyone have good ideas about this? Thanks in advance.

Answer 1

PS: I am using MS Access Database.

Answer 2

Dim ADOXCatalog As New ADOX.Catalog
Dim ADOConnection As New ADODB.Connection

Try
ADOConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\db1.mdb;" & _
"Jet OLEDB:Engine Type=4;")

ADOXCatalog.ActiveConnection = ADOConnection

Dim col As ADOX.Column
For Each col In ADOXCatalog.Tables("Table1").Columns
If col.Properties("AutoIncrement").Value = True Then
Console.WriteLine(col.Name)
End If
Next

Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
ADOConnection.Close()
End Try

Answer 3

ADOX::PropertyPtr pAutoIncrProperty = m_pTable->Columns->Item[_variant_t(fieldInfo.m_strName)]->Properties->Item[_variant_t(_T("AutoIncrement"))];