Re: MS-access file on Oracle 9i

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 19 Nov 2003 14:42:32 -0800
Message-ID: <1069281774.819052@yasure>

Glen A Stromquist wrote:

> Daniel Morgan wrote:
>

>> Mads wrote:
>>
>>> Hi,
>>>
>>> I am wondering wether it's possible to connect an Oracle 9i
>>> client-version to a MS-access file. If it's possible please let me
>>> know how.
>>>
>>> /Mads
>>
>>
>>
>> No. But for what possible reason would you want to do it? Take 
>> whatever is in MS Access and put it into the real database.

>
>
>
> Actually you can, thru heterogeneous services you can connect to an
> MSaccess "database" from an Oracle database thru ODBC and treat it like
> a linked database.
>
> Unless they discontinued that in 9i...
>
> hth
>

You can do what you suggest but it is the Oracle database making the connection. You still can not connect the SQL*Plus client to MS Access.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Wed Nov 19 2003 - 16:42:32 CST