Unanswered: Getting Table/Columninformation from MS Access
I'm writing an application (in Java), which should analyze, compare and copy databases/tables. So my MySQL part works and now I'm trying to make the Access part and have some probs. I get some info with ResultSetMetaData but I miss the information if a column is primary key or an index at all. Please, has someone an idea how to get the whole information about a table's structure?