Re: Oracle and Microsoft access

Can Access, through ODBC, update an Oracle table? I was under the impression that ODBC allowed Access Read-Only access to Oracle tables...

TurkBear wrote:

> I don't think there is a non-trivial way to access ( not Access) a non Oracle
> database from within Oracle in the way you want...You could, however, do the
> reverse...Set up a link to the Oracle database table from within Access and
> update at will...
>
> Pierre Pavlenyi <pavlenyi_at_ca.ibm.com> wrote:
>
> >I am trying to connect a Microsoft Access database to an Oracle database
> >in the following manner:
> >
> >In Oracle, I want to know if I can create a table/alias (call it
> >MSAccessAlias) that points to a table in the MS Access table. I then
> >want to periodically (say, once a day), copy the contents of
> >MSAccessAlias to an Oracle internal table (call it OracleMSReplica).
> >
> >Is this possible? If so, how would I go about implementing this
> >solution?
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Received on Fri Mar 17 2000 - 10:29:55 CST