Re: Questions regarding MS ACCESS, ODBC and ORACLE

From: Lyra <vtsien_at_iris.ctd.anl.gov>
Date: 1996/11/21
Message-ID: <01bbd757$322913a0$0bad8992@lyra.ctd.anl.gov>#1/1

Access 2.0 needs Oracle table with an index to update, but Access 7.0 doesn't have to. The only problem with Access is the import and export. The export will change some of the data types in Oracle. Just watch out. Otherwise, everything is OK.

Arnold Hitch <trident_at_worldgate.com> wrote in article <01bbd597$85a3c0a0$1002a7cf_at_tarantula>...
> Has anyone have any comments about problems using MS ACCESS to Oracle
> through ODBC? I have heard there are a number of problems with how ACCESS
> deals with Oracle objects, specifically private and public synonyms. I am
> also curious if any one has successfully had ACCESS perform remote
update,
> insert or delete through and Oracle database link.
>
> Your thoughts would be appreciated.
>
> TIA
> Arnold
>
>
Received on Thu Nov 21 1996 - 00:00:00 CST