Primary Key info

  • Thread starter Thread starter DZ
  • Start date Start date
D

DZ

Is there a way to return the name of the field(s) that are the Primary key?
Access 97

Thank you
 
Is there a way to return the name of the field(s) that are the Primary key?
Access 97

and / or if a particular field is part of primary key

Thank you
 
Take a look at the DescribeIndexField() function towardss the end of this
page:
http://allenbrowne.com/AppRelReportCode.html

The function shows how to loop through the Indexes collection of the
TableDef. If the Primary property is True, list the Fields of the Index.

The code is is part of a utility for Access 2000 and later, but the function
should work in A97 if you remove the Private keyword.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

building a string in a public function 1
Access 97 performance 1
Primary Key Value 3
Linking Files and Select Unique Record Identifier 2
Primary Key Field Showing Duplicates 1
MS Access Avoiding redundancy 1
Delete primary key 8
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5

Back
Top