Re: Linking Access 2000 to Oracle 7.3.4.5

Sorry, but you will have to be a little clearer:

What do you mean by 'can't locate Oracle'?

In Access 2000
Use
File..External data...Link Tables
select ODBC databases as the type,
Find the DSN for your Oracle database
Use it to pick the table(s) you want to link.. ( this is not a lot different, as I recall, from earlier Access methods)

mtbkab_at_yahoo.com (Michael Brown) wrote:

>"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<thvdqsl78uog6d_at_beta-news.demon.nl>...
>> "Michael Brown" <mtbkab_at_yahoo.com> wrote in message
>> news:9839f5a4.0106070856.72a9fab_at_posting.google.com...
>> > I am attempting to link access 2000 to an Oracle database (7.3.4.5).
>> > The Oracle database is located on an NT server. Currently I have several
 Access
>> > 2.0 databases linked to Oracle from several desktops. We are trying to
 upgrade
>> > to Access 2000 but I can't locate Oracle with it.
>> >
>> > Please. . . any suggestions?
>>
>> Only if it is not too much trouble for you to post any specific error
>> messages.
>>
>> Regards,
>>
>> Sybrand Bakker, Oracle DBA
>
>I wish i could provide more information. I should have explained that I'm not
>familiar with ODBC's, networks, oracle, etc. I just know that I didn't have
>any trouble whatsoever linking to Oracle through Access 2.0. Now that we are
>making the upgrade to access 2000 I just can't locate Oracle. I'm not sure
>where to begin.
>
>Please. . . any suggestions . . . actually I need more like step-by-step
>instructions.
Received on Fri Jun 08 2001 - 13:08:13 CDT