Primary Key in Access DB

Results 1 to 2 of 2

Thread: Primary Key in Access DB

  1. #1
    Join Date
    Dec 1969

    Default Primary Key in Access DB

    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? :(

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default CROSSPOST


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts