Re: Oracle vs Access

I agree, SQLAnywhere is an outstanding product, esp for replication. Access can't even be compared! SQLA is probably the only db that can handle enterprise business, and yet still have s small enough footprint so it can run comfortably on laptops etc. Having developed a custom replicated Access v2 (yep, v2!) system, I sure appreciate the thought and general reliability of SQLA.

But be warned: replication, and all the issues involved, is not for the faint-hearted!

Chhers, Max

-- 
MAX HUGEN
Hugen Enterprises, 207 Flood St, Leichhardt NSW 2040, Australia
Email: maxhugen_at_ozemail.com.au              Tel: +612 9560 3061
....for world-class, custom business software......

keithm_at_sweeney.demon.co.uk wrote:


> 

> >In article <35CA5DFC.C2DDCB77_at_ccis.adisys.com.au>,


> >  Neil Fisher <neilf_at_ccis.adisys.com.au> wrote:


 


> > There may be instances where laptops become deployed as stand alone pc's

> > to be reconnected at a later stage. During this disconnection from the

> > main server, there would need to be some sort of  local database access


> > which can be updated on the main server when the laptop is reconnected.


 


> > Can anybody help me by outlining a list of for and against for both

> > products. This list can contain anything from price to performance,

> > scalability, etc.

> 

> Our experience is that Access in a multi-user situation is a disaster unless


>  all users are on the same LAN segment.

> 

> Try SQLAnywhere as suggested by another responder or look at Oracle Lite.