Creating an MS Access 2003 Front End for an Oracle 10g Express Edition Database

(Jayaram Krishnaswamy) Enterprises have data stored in different kinds of databases from flat-files to relational databases. It is often necessary to generate reports from disparate databases. The rapid application development that is possible with MS Access allows one to rapidly deploy the report created to the intranet web site without writing so much as a line of code. This tutorial shows you the steps involved in creating a MS Access front end in the form of a Data Access Page for an Oracle 10g Express Edition database. Linked tables are used which are at the heart of distributed queries. The MS Access project links to the Oracle XE tables using an ODBC connection. The tutorial also shows how to create a data access page using data from the Oracle XE and host it on the intranet server.