what is the advantages and disadvantages Oracle ?
what is the comparison between Ms Access and Oracle?

Thanks a lot...

    Autch...compare Oracle with Access?????

    Access is for really small, home/personal databases, with about max of 3 simultanus connections and a max of about 10000 entries.

    Oracle (expensive) is meant to deal with huge databases, for hundreds of thousands of users and even more entries. It is more stable etc.

    And then: Access is only a database, Oracle a DBMS (Management System) with a lot more functionality.

    Hope this helps

      weird question... anyway if you are planning to code a small application access works just fine, but for reals apps you should use Oracle or another real data base manager, note that access is not a real data base manager, and of course it cost much less, that's why you should plan what you want to do, how much money do you have, how much the DB will grow, etc.. Spend 8000$ on oracle for a 200 register DB and your boss will be very angry with you or spend 200$ for a database with 300.000 registers and growing and your boss will be very angry when your system crashes.. so.. take care about your choice.

        5 months later

        Cheers for the question - it came in handy for my project

        MSc Computer Science Student
        Hertfordshire University
        England

          13 days later

          Is there something I can reference that shows why I would want to use access instead of Oracle or visa versa?

          Thanks

            3 months later

            I want to know more about the comparision to Ms Access and Oracle.
            Thanks.

              2 months later

              The best way to compare the two systems is to create a basic database in both and work it out for yourselves. I've been doing just that and though it takes ages it actually makes you understand exactly what the comparisons are. There are too many to list here. Did you want to compare it on a developers perspective or an end users perspective?

                7 days later

                me too!

                BSc Computer Science
                Coventry University
                England

                  thanks for ur answer

                    a month later

                    Why i must use access but not oracle in the small project? have to consider cost for a company? consider small database? how is the relation links compare with oracle?

                      a month later

                      Hi ,
                      If the database size is expected to be about 3-10 million rows, can Access 2000 handle it. I am not doing any front end development. It is only for querying data to answer businesss questions - Single user.
                      Cab any body point me to a technical spec document that quantifies the performance of Oracle vs Access.
                      Thanks in advance
                      Anand

                        Hi ,
                        If the database size is expected to be about 3-10 million rows, can Access 2000 handle it. I am not doing any front end development. It is only for querying data to answer businesss questions - Single user.
                        Can any body point me to a technical spec document that quantifies the performance of Oracle vs Access.
                        Thanks in advance
                        Anand

                          8 days later

                          Access:
                          -Part of Office Suite, Easy Integration With Other Tools
                          -Very Easy to Use
                          -Graphical Interface
                          -Not Good for Large Data Sets
                          -Not Good With Multiple Users

                          Oracle
                          -Industry Standard
                          -Very Secure
                          -Very Expensive
                          -Large 10GB space, use 256M RAM
                          -Advanced Features
                          -Multiple Users

                            8 days later

                            what the security differences between Oracle & MS Access? Broad question I know.

                              24 days later

                              i want compare oracle and Ms Access Please Send More details about it with me very soon

                              thankyou
                              \

                              \
                              \rohan

                                3 months later

                                have you considered microsoft date engine...which is based on access 2000 tables but uses a data base managment system to handle indexing and maintain stability. You can lookup more information at msdn.microsoft.com and a do a search for access vs msde

                                  Write a Reply...