Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: MS-access file on Oracle 9i

Re: MS-access file on Oracle 9i

From: Glen A Stromquist <glen_stromquist_at_no.spam.yahoo.com>
Date: Wed, 19 Nov 2003 23:09:43 GMT
Message-ID: <XKSub.99583$jy.47104@clgrps13>


Daniel Morgan wrote:

> 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.

I assumed it would be via an oracle database, but the OP was a bit vague, I can't imagine why someone would have the client if they werent connecting to an oracle db in the first place ;-) Received on Wed Nov 19 2003 - 17:09:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US