I just tried with mine and it didn't work there either. The error
report says "Driver doesn't support..". I found a method named
getIndexInfo though that returns an item named non-unique. In theory I
guess if an index is "non-unique" then there can be duplicates.
Therefore if it is not "non-unique", then it is unique. Right? That
might be a round-about way of getting at it.
> Hello everyone,
> I'm looking for a way to retrieve the primary keys of an MSAccess
> Database, using JDBC/ODBC. The only one I found is to
> getDatabaseMetaData and
> getPrimaryKeys on it. But it doesn't work at all with MSAccess driver.
> Does anyone know how to do that another way.
> Thanks in advance for answering.
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.