Hi all, I tried to use the TableGen tool I mentioned in the previous post with a database I had created using Microsoft Access (This is because there's this application I'm currently developing and the end user wants it to work with MS Access), but ran into a problem. The output when run shown below:
Here's the portion of the code I figured generated all them Exceptions.
Question  I'm begining to think that it may be that MS Access doesn't support the use of foreign keys. Is my diagnosis right? Question  On the web page for TableGen, it was tested on MySQL,Oracle, DB2, Prostgressql and Sybase. All the big RDBMS.... Someone who should know once told me MS Access is an RDBMS too (and I've believed this all these while), is this true? I mean if it doesn't support the use of foriegn keys, then how can it be relational? Please let me know what you think. Thanks.
Femi, Access is definitely a relational database. It does support foreign keys. Apparently, the driver doesn't support the metadata methods you are calling though. I'm linking to your other thread in case someone wants to find it later.