Oracle and ms-access are two complete diffent products. In fact, they don't
even do the same thing!
ms-access is a forms and visual basic development tool. Ms-access is not a
database product.
Oracle is just the reverse:
Oracle is a database system. That means you can store data and
information in that box. However, oracle does NOT allow you to build forms,
or reports.
So,
ms-access = Graphical Interface tool
Oracle = data base system with no user interface
What this means is that you can build your application with ms-access, but
store the data in Oracle. After all, as mentioned, *just* having a database
system like oracle is not much use unless you have a tool to connect to the
database. To "access" a database, you often will use the product called
ms-"access". Hence, ms-access most certainly has the correct name, as it is
not a database.
Ms-access thus lets you choose what database engine/system is going to store
your data. Out of the box, you can use what is called the JET database
engine. This engine is most commonly used with ms-access. However, just like
Oracle, the JET database engine does not have any forms, or GUI ability.
You can also use Microsoft's sql-server with ms-access, and once again sql
server does not have the user interface tools.
So, your question is really about two complete different products. I mean,
if you use the Oracle database, you still have to write your application.
That application can be written in ms-access, a web site, or even VB. So,
generally you choose your database engine, and then choose the tools with
which to write the application with. So, ms-access is just one of those
tools that you write the application with, but it is not a database.
Since ms-access can be used as a interface to most databases, then the
limits, or amount of data that ms-access can handle is going to be based on
what ever database system you are using or going to connect to with via
ms-access. That system as mentioned could be Oracle, Sql-server, Sybase,
MySql...etc. etc. etc. etc etc.
