title: Control which columns become primary keys with Microsoft Access ODBC link to Oracle
body: <p>When you create a Microsoft Access 2003 link to an Oracle table using Oracle's ODBC driver, you are sometimes asked to state which columns are the primary key(s).</p>
  
  <p>I would like to know how to change that initial assignment, or even how to get Access/ODBC to forget the assignment. In my limited testing I wonder if the assignment isn't cached by the ODBC driver itself.</p>
  
  <p>The columns I initial chose are not correct.</p>
  
  <p>Update: I never did get a full answer on this one, deleting the links then restoring them didn't work. I think it's an obscure bug. I've moved on and haven't had to worry about this oddity since.</p>