Escape from Access DB

Do you like Microsoft Access? Well, thanks to an intuitive and powerful user interface and being bundled as part of Office, it has established a niche for itself in many organisations, sometimes unofficially.

The combination of recordable macros, wizard-generated reports, query-by-example and, crucially, the provision of program support using Visual Basic for Applications has made MS Access the tool of choice for legions of developers of varying levels of ability and technical proficiency.

Not only has this led to a proliferation of applications, it has also produced a proliferation of "rescue" projects as those applications have grown in scope, size and complexity. For enterprise developers using Java this data need not remain out of reach thanks to the wonders of JDBC-ODBC bridges.

The article continues at http://www.regdeveloper.co.uk/2006/12/21/access_odbc_jdbc/