Finding PK of given table name in Access? 1

[Vachaun22]

I need to find the primary key field in a given table from Access just a SQL statement in order to hide that field from the form.

I'm not sure what I need to query on in order to find this. Can anyone give me some suggestions? Thanks in advance.

 

[PHV]

You may use this VBA function:

Public Function get1stFieldOfPK(strTable)
On Error Resume Next
get1stFieldOfPK = CurrentDb.TableDefs(strTable).Indexes("PrimaryKey").Fields(0).Name
End Function

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Vachaun22]

I'm actually coding in VB6 using ADODB connections, so that unfortunately won't help I don't think.

 

[PHV]

You may play with an ADOX.Catalog object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Vachaun22]

I did find that, but that would require a bunch of code changes.

I did however find the OpenSchema functionality, which I'm going to use. It seems to work properly. Thanks for the help!