Re: Oracle vs Access

> anyway, I have yet to see anything Oracle-based work worth a damn on our
> network without twenty times as much fiddlin' as any Access app I ever put
> together.

In our environnment, all the major components of our information systems are based on oracle databases. They are character based applications, but
several modules support more than 12000 transactions a day without a hitch.
All the people who tried to build large information systems with ACCESS here
failed miserably. Someone created a several GB datamart, and it is in a so
miserable condition, that it will require a total reconstruction, based on
an ORACLE database.

In our experience, ACCESS is only tolerable for small single user, non critical applications.

We have two problems with ORACLE: the growth control of a database must still be done manually and frequently (when a disk is full on a server, the database hangs). There are also several cases where important tools have been totally changed by Oracle without warning. This is, for example,
the case of the on-line backup tools between the version 7 and 8.

But there is no doubt that ORACLE provides us a performance, a degree of reliability, a flexibility for integration between applications and the possibility to build strong and robust applications that ACCESS cannot even dream of.

Emmanuel Baechler
Lausanne
Switerland Received on Tue Aug 11 1998 - 00:00:00 CDT