Does someone know how to determine in ASP what column is a primary key in Access 2000 DB? <BR>I tried schemas... the PRIMARY_KEY is always Null. I tried ADOX, but it returns me that ALL fields in table are primary keys :) <BR>Even made a test table with 2 same text fields but one is Primary key and compared their Field.Properties in debugger! <BR>Any way to get it? <BR>I know, I can check indexes and look for index with PrimaryKey name. Access DB creates all primary keys indexes with this name, but this is not a rule! I can make a table with CREATE TABLE SQL statement and it won&#039;t make me such nice index :) <BR>So again... Any way to get which column is a primary key? :(