[HELP] MSAccess picks wrong keys

Using MS Access 2003 and pgsql-odbc 7.03.02.00.

Today I added a column (Course_LongName) to a table (Courses), when I
relinked the table in Access decided that that column should be part 
of
the composite primary key. The Correct Key is "Course_Number",
"SchoolYear", "SchoolYearSemester". Access Chooses "Course_Number",
"SchoolYearSemester", "Course_LongName" every time. I can't get it to 
let
go!

I've deleted the link and relinked/refreshed. I've checked and 
unchecked "Recognise unique indexes" to no avail. Is there any way I 
can
make this go right?

How does Access choose keys? Can I trick it?

Is there a way to force Access to display the key choosing interface 
when
linking tables from postgresql?


Aaron Spike

My Table description:
                     Table "public.Courses"
       Column       |              Type              | Modifiers
--------------------+--------------------------------+-----------
 Course_Number      | character varying(7)           | not null
 Course_ShortName   | character varying(12)          |
 Course_Credit      | double precision               | not null
 ModifiedBy         | text                           |
 Modified           | timestamp(0) without time zone |
 Course_Description | text                           |
 SchoolYear         | character varying(6)           | not null
 SchoolYearSemester | character varying(1)           | not null
 Course_LongName    | character varying(255)         |
Indexes: Courses_pkey primary key btree ("Course_Number", 
"SchoolYear", "SchoolYearSemester")
Triggers: courses_update_modified



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend