getPrimaryKeys not working with MS Access

Just a solution how to get the PrimaryKeys on MS Access when using

ODBC Bridge. There are 20 postings here but no solution. Here it is:

ResultSet trs = connection.getMetaData().getIndexInfo(null, null, table, false, true);

while (trs.next()) {

String tmp = trs.getString(9);

String primaryKey = trs.getString(6);

if (tmp != null && primaryKey.equals("PrimaryKey")) {

System.out.println("Primary Key found: "+tmp+", "+primaryKey);

}

}

trs.close();

http://jdbc.developerfaqs.com/q_jdbc_79246.html