Difference between MS Access and Oracle

Answer Posted / kani

1.Oracle is multi-user where MS-Access is not.

2.Oracle's features for distributed transactions,
materialized views and replication are not available with
MS Access. These features enable Oracle to efficiently
store data for multinational companies across the globe.
Also these features increase scalability of applications
based on Oracle.

3.We can't create sequence in Microsoft Access.We create
sequence in Oracle.

4.Oracle database is more secured than MS-Access. Oracle
can handle a database having million records very
efficiently, but MS-Access has no such quality like Oracle.

5.oracle is client server technology based while Ms-Access
is not.

6.Oracle follow 11 rule of E.F CODD and access follow 7
rule, oracle give better query performance in comparison to
access, oracle perform high security feature like system
manager, oracle can store unlimited data in access limit.

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is access a good database?

592


how can I open an MS Access database that has been converted to a current version?

666


Is microsoft access free?

564


How can you create a form in ms access 2013?

646


What is microsoft access used for?

607


What is the difference between access and excel?

606


What is the main component of ms access database?

558


What are the advantages of ms access over ms sql server?

643


I have a reference table called 1. of 2 fields called 1.BadgeGroups(BG)and 1.Badges(B)like BG G aa 10 aa 11 bb 12 bb 13 bb 14 Using MS Design View Table 2 has 3 fields called 2.name, 2.badgegroup and 2.group In Table 2 called 2. they calls Table 1 for 2 fields BUT with the second field 2.badges, I want the combo box only to display the 1.badges where 2.badgegroup = 1.badgegroup The current select I have is for Table Data View Row Source is: 2.badgegroup is filled from a Combo box using Select Distinct etc from Table 1. Tried different syntax's but still lost, looking for some help SELECT 1.[BadgeGroup], 1.Badge FROM 1. WHERE 1.[BadgeGroup]=Me.2.BadgeGroup); I can populate 2.badgegroup with a

2151


How to find out what version of microsoft access I have?

602


Can multiple users access the same access database?

563


What can I use instead of microsoft access?

597


What is the use of pivot table?

657


Can you put an access database on sharepoint?

550


What is record in ms access?

630