How Compatible are Oracle and Microsoft Access?

Page content


Oracle has been in the programming sector for quite some time. It has proved to be an essential tool in developing various applications, giving clients quite an impressive tool for their ideas and projects. However, those in programming have seen a correlation between Access and Oracle applications and have often projected integration of the two so as to create one package that could pummel the future of programming and bring web design a notch higher. This has become the subject of exploration with an emphasis on compatibility. How well can the two applications work together? Is there a possibility of positive results if one tries to make Microsoft Access and Oracle work together? Are they compatible really?

Feature Attributes

There has been a heated debate about the capability between these two applications. Oracle software is currently being used by more than a hundred and forty countries for their data needs. In order to meet this tall order, Oracle has added some more features to its application.

It has developed a new set of functionality and parameters depending on the location of the user. This is known as localization. The software is designed to support businesses and legal requirements in United State government. In other world countries, it has also been localized according to customer’s database needs.

Local customized Oracle software has been developed; thereby localization is applicable as to the country of origin - that is, the country it was originally created for. Brazil is an example of such localization. Brazilian Oracle supports localization and it has some additional configuration at some module functions such as GL, FA, PO, OM, INV, CE, AP, AR billing, PAC, and a new Integrated Receiving (IR). This implementation only applies to Brazil. There are about three hundred varied process variances required by Brazilian Oracle localization.


While Oracle is an ORDBMS (Object Oriented Relational Database), Access is a RDBMS (Relational Database) only. This makes the two have a difference in terms of needs like interface requirements which either can act as a platform to serve the other. This makes the two compatible.

High assessment is required when you want to implement any global Oracle roll out. Normally, to make this program compatible with a Microsoft application, you have to be very good in programming to achieve even the smallest compatibility. This is because Oracle is tailor made while Access is compact. It comes with functionality that is built-in. Oracle can handle much more complicated databases whereas Access is a small application with limited database functionality.

Since Access is not as secure as Oracle, application within the Access platform can be utilized through Oracle to provide security.

Due to the optimal performance of Oracle, expert programmers perceive a lenient compatibility between Oracle and Microsoft Access and argue that, the two indeed can work together. By ignoring the context of compact manufacturer or rather the developer specifications, one can integrate the two applications using their own interfaces and application features. This does not mean inter-twining applications as a compact program, but to choose a facility in each and using it in another and vice-versa. Eventually, the experts deem that this is a great way to get results from each through hand picking applications from either.

  1. Prepare the MS-Access environment.
  1. Define ODBC connectivity.

  2. Prepare the Oracle Environment.

  3. Configure and Start the Oracle Listener.

  4. Configure Oracle HS.

  5. Configure Oracle connectivity to Windows Machine.

  1. Create a database link.


Microsoft Office Access is a very powerful database tool which meets technological upward growth and development in computer applications. By using Oracle, which is quite essential in the database creation, the two would produce significant results in database creation.