How to list the primary key columns in an Access table

You can get a list of the columns in a primary key manually, but depending on the task, you may want to handle it programmatically instead. Susan Harkins shares a VBA function that uses ADOX objects to obtain the column information.

This download is also available as an entry in our Microsoft Office blog.