Pros and Cons of Oracle over Access?

Question

I need to know the disadvantage and advantages of using the Oracle database package over Access and vice versa....Pls...Does anybody know? Or even a site where I can find the answer???

Answer 1

Hi Lucky,

There is some very good information here on that -

http://wiki.answers.com/Q/What_are_the_d...

hope this helps :)

Answer 2

Oracle uses some of the SQL technology developed at IBM, usually in a UNIX context (which is why they are distributing their own version of Linux).  Microsoft Access was not only developed to run on Windows, and as part of their consumer oriented Office Suite, its focus is on the consumer and on (relatively) small databases.

That scale is the difference: I'm a Microsoft-hater from way back but when one  group I volunteer for needed a small database, of course it was in Access.  While fifteen years ago, I worked as a data entry operator on the Oracle-based personnel database of one of our states -- all of which have to employ enough people so Oracle is the obvious choice.

Answer 3

You cant compare Oracle with Access.

Access is used to generate small scale applications whereas Oracle has applications in  vast areas. Access is for small stand alone appl.

Oracle for client-server network technologies.

You can choose between them depending upon your apllication size and where you want to use it.

Answer 4

Access - toy for storing data.

Oracle - high performance RDMS (relational database management system).

In particular.

Access

light weight, cheap, simple to learn and use, single/few users only, best for home/small office users.

Oracle

scalable (will utilize multiple CPUs), can store massive amounts of data (terrabytes), supports large numbers of users, dependable

Answer 5

Access will run on just about any low-end system, Oracale takes more hardware.  Oracle is more difficult to set up than Access, more difficult to manage, although you can still use Access as the "Front End" to an Oracle database.

In every other respect, Oracle beats Access.  It's really kind of like comparing a childs electric-powered "hot wheels" that can go 4 or 5 Miles per hour, down-hill, to a Formula 1 Ferrari that can go from a standing stop, to 100 MPH, back to a standing stop in 6 seconds, capable of top speeds well over 200 MPH.  It also takes a LOT more skill and experience to drive the Formula 1 car.  Put a kid in one, and if they can even get it moving, they'll probably kill themselves in about 4 seconds.  One is a toy, fully capable of taking a person from point A to point b, eventually.  The other will take you there with plenty of horsepower left over.  Oracle and Access really are not even in the same league.  If you are writing a business application that is going to be accessed by multiple people, a true SQL server is the only way to go, Access is not capable of handling it with any kind of efficiency.  If you are writing a stand-alone app, creating a database to keep track of your music, Access is fully adequate and will take you 1/10th the time to learn and make the database, although you'll gain a lot more knowledge on the trip using Oracle.

Again, if you are creating something from scratch and want the learning process, consider using MySql in place of Oracle, it's Open Source (free) and runs on Windows, LInux, Mac, Unix, is powerful, fast, easier than Oracle, with more free/community support.  Can still be used as the back-end with Access as the front-end (graphical component) using ODBC data connectors, or you can develop the front-end with Open Office.org's "Database" application which would again make it fully cross-platform, able to be accessed by any operating system that Open Office.org is available for (Open Office is also fully Open Source (Free))

http://openoffice.org

http//mysql.org