I am writing software that basically stores all information in an access file (*.mdb). I am re desiging the database schema, which means new design within the .mdb file.

My questions are previously integrtiy constraints did not exist in the database in much of any degree. I am assuming Access can do this.

However can I use SQL to create the tables and constraints programatically? Or do I need to use the access program?

How well does access interact with code that is strictly written in SQL, and not trying to use access specific features?

My previous experience was with Oracle and JDBC, so I am curious how much I need to relearn to work in MFC + Access (via ODBC).

Gol