Re: Oracle8 vs. MS Access

[Quoted] MS Access requires access to the file, since it is file based. That also means all user must be able to get at the same file server (which is an admin nightmare in a large organization) and, the biggie, all users have the ability to overwrite the file on the file server. Locking is done at the, you guessed it, the file level. Big downer since you can't have "row level locking". Since file access is 100's of time slower than memory access, you'll crap out on a server with more than 10 heavy users.

Clients request information from the Oracle server. Only the Oracle server has access to the files. Locking is handled in [Quoted] memory by the server at the row level. Since the server can do so many things in memory, it is blistering fast compared to a file based database like MS Access. Also, the Oracle server is nearly impossible to hack or crash so it is very safe and stable.

Keith Vasilakes wrote:

> If more than one user EVER needs to access the data use Oracle.
> If you are writing a standalone progran that will never need to talk to another program or be used over the network, or
> have multiple users use Access.
>
> Oracle is Fast.
> Oracle is a real relational database
> MS Access is an ISAM, which means it is basically a sequential file...
> MS Access will most certianly give you an HUGE upgrade head ache down the road.
>
> Oracle is better for your career....
>
> Greg Williams wrote:
>
> > I have been asked to research the difference between using a Oracle8
> > database vs. MS Access 97 database. If you could give me specifics on the
> > differences and advantages/disadvantages of the two databases I would be
> > most appreciative. Security opinions/detials would be a plus!
> >
> > Greg Williams
> > Lambda Consulting
> > greg.williams_at_lambaconsulting.com
Received on Sat Dec 12 1998 - 00:00:00 CET