answersLogoWhite

0

You migrate to a larger scale DB for reasons such as the limitations that access may have. Access is traditionally a desktop database,but it is used in large corporations that may require control of users and other features that will and can make life so much easier. Unfortunately, Access does have its limitations and its performance begins to degrade depending for example, when you have extremely large tables, the user population increases considerably, then access time suffers. Migrating to Oracle which is very competent and has a reliable RDBMS; can hold many more tables than Access and was built to handle a large volume of traffic which is not limited to only users, but processes many many more transactions than Access can. Hope this helps.

User Avatar

Wiki User

19y ago

What else can I help you with?

Related Questions

What are four database programs?

Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.


What is example of a computerized database?

MySQL, Oracle, Microsoft Access, Borland Paradox, etc.


What is an example of a computerized database?

MySQL, Oracle, Microsoft Access, Borland Paradox, etc.


Examples for dbms and rdbms?

My sql, Microsoft sql , Microsoft Access, dBase, Filemaker pro are the examples for dbms and oracle and sql server are the examples for rdbms


How do I create a form which will then upload to a database that I can access in Microsoft Access?

Have your form's input insert into a database (SQL, Oracle, etc) then access that database through Access's ODBC connection.


What are the differences between Microsoft Excel and Oracle Database?

Excel is a spreadsheet program. Oracle is for databases. Excel has some databasing capabilities, but it is not its main purpose.


Is there accounting software that has ready-made compatibility with Oracle databases?

Microsoft Excel and Access offer the ability to interface with a Oracle database. This is provided through the Office Suite.


What is the most commonly used database application?

Oracle, MS SQL Server, Informix, Sybase, DB2, MySQL And for "toy" applications, MS Access.


In what situation would a company choose to use a Microsoft Access database over an Oracle database?

To save lots of money.


Examples of database packages?

Sure thing, honey. Some popular database packages include Oracle Database, Microsoft SQL Server, MySQL, and PostgreSQL. These bad boys are used by companies big and small to store and manage their precious data. So, pick your poison and get ready to dive into the world of databases!


What are database software available in market?

Available DBMS are DB2, Oracle, Sybase, and Microsoft SQLServer. There are also Microsoft Access, mySQL, FileMaker. Hyperion, hSQL, Firebird, Postgres, and more.


What are some types of database software?

Microsoft Access is a common example of database software. there is also Oracle, DB2, Microsoft Report Server, PostgreReport, MyReport, Reportite, FileMaker and Sybase Adaptive Server Enterprise.