using ado to get the Primary Key Column name from MS ACCESS

[sriram_sasken]

Hello ,



I am trying to get the Column names from all the tables which are PRIMARY KEYS ONLY. I have tried the following ..


_ConnectionPtr m_pConnectionPtr = NULL;

_Recordsettr m_pRecordsetPtr = NULL


// cONNECT TO MS ACCESS DATABASE SUCCESSFULLY THEN


m_pRecordSet = m_pConnection->OpenSchema(adSchemaTables)

.. Then I have googled so many sites but iam not able to get the information. Can some please five me a Clue.


Thanks,

Continue reading...