Re: MS-Access -> ORACLE
Date: 1996/12/11
Message-ID: <01bbe7ae$3f87a2c0$347315ce_at_toddv.retailplanning.com>#1/1
Don't use Microsoft's or Oracle ODBC driver. Get a third party one.
Access needs to go through Jet to ODBC to Oracle so its not very efficient. An Oracle database requires significantly more administration than access (and most others). Be prepared to have someone become a "real" dba.
You may want to consider SQL Server, it is a smoother migration and Microsofts tools are specfically geared to work well with it.
Todd Verstraten
mailto:tverstrat_at_tier3.com
http://www.tier3.com
Shane Cunnane <scunnane_at_wirehub.nl> wrote in article
<scunnane.9.013C0D3E_at_wirehub.nl>...
> Hi, we're considering migrating from an solely MS-Access 2.0 environment
to an
> Oracle7 Workgroup Server with MS-Access 2.0 clients. Does anybody have
any
> experience of problems/issues/pitfalls in going this route ? Also is
there a
> particular ODBC driver that we should opt for ? And finally apart from
the
> Oracle7 Server package is there any other software that we should also
get at
> the same time ? (we're probably going to start developing with VB4
soonish).
>
>
> Thanks, Shane
>
Received on Wed Dec 11 1996 - 00:00:00 CET