Creating an MS Access 2003 Front End for an Oracle 10g Express Edition Database
page 1 of 5
Published: 28 Jun 2006
Unedited - Community Contributed
In this tutorial Jayaram demonstrates the steps involved in creating a MS Access front end for an Oracle 10G XE back end. The user interface on MS Access takes the form of a Data Access Page hosted on the Intranet.
by Jayaram Krishnaswamy
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 35097/ 61


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.

Oracle 10g Express Edition [xe] is Oracle's latest software, downloadable from this link.  It is an easy to administer, free to develop, deploy and distribute product ideal for those who are interested in working with a cutting edge RDBMS.  It has a sample database with which the front end on MS Access has been developed.  After downloading and installing the Oracle 10G XE software, one has to use the Admin credentials to login and give the login permissions to the front end developer.  This is described in considerable detail in the provided link.  Figure 1 shows the object browser in Oracle 10G Express Edition listing all the tables in the sample database, HR.

Figure 1

View Entire Article

User Comments

Title: help   
Name: shirish
Date: 2011-10-30 2:57:18 AM
figure in the above document is not visible??
so please upload new web page here
Title: Shaik   
Name: Sabir Hussain
Date: 2011-02-12 11:36:17 PM
This is really great article for those who willing to know like these things in ever their life..

Really great stuff......
Title: shri   
Name: sreedhar reddy
Date: 2010-06-01 2:48:46 PM
great article for those to connect to oracle using access.thanks a lot

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-05-24 9:11:04 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search