Re: Oracle Personal Server 7 vs Access

release_at_iastate.edu (Troy Downing) wrote:

>I was wondering what were some of the Differences between Personal
>Server 7 and Access, advantages to one or the other, and which is the
>better product.
 

>Troy Downing
>release_at_iastate.edu

Personal Oracle and Access are not really in the same catagory. Personal Oracle is a true database engine where Access is a glorified flat-file database you access through DLLs.

If you have a simple app or your users are not real computer literate, Acces is probably the better fit. If you need any horsepower, need to perform complex SQL expressions or have an Oralce installation already (and may need to extract data from one to the other), then Personal Oracle will work better.

If you do go with Oracle, don't skimp on resources, especially RAM.

--
Mark Wagoner
mwagoner_at_iac.net