Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle compared to Access
You try to compare two products which are incomparable.
Oracle is a client/server based product, Access isn't
In Oracle you can distribute your database on several disks, in Access a
database consist always of one single file
In Oracle you have after image journalling aka redo log, in Access there is
no such thing.
I could go on for a while. Honestly compared to Oracle Access is a toy. I
must admit I like the frontend part of it, but my experience (I have been
working with it for 4 years) tells me any Access database of more than 64 M
will crash a few times per year. If an Oracle database crashes (usually
caused by power dip and hardware malfunction) you can recover from it.
Hth,
--
Sybrand Bakker, Oracle DBA
<kaminari85_at_my-deja.com> wrote in message
news:7v7a9h$66r$1_at_nnrp1.deja.com...
> I am familiar with access. I was wanting to know the advantages Oracle
> has over Access. Thanks for any quick thoughts.
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Oct 27 1999 - 12:35:27 CDT
![]() |
![]() |