Find Primary Key in table

[EddStewart]

Hi,

I'm importing a number of tables from an outside .mdb into my DB and need to automatically determine which field in the imported tables is the primary key. Can anyone help with some VBA code that can do this?

Kind Regards,

Edd Stewart

 

[vbajock]

This page shows how to retrieve database schema using either ADOX or DAO:

http://msdn.microsoft.com/library/d...ry/en-us/dndao/html/daotoadoupdate_topic6.asp

I've never used DAO to do jobs like that, but using ADOX, the value you are testing for is adKeyPrimary = true.

Although this page shows how to create a primary using ADOX, it also illustrates the properties that you would interrogate (pay close attention to adKeyPrimary) if you looped through an mdb and tested each table:

http://support.microsoft.com/default.aspx?scid=kb;en-us;252908