Re: Microsoft Access - Oracle8i

On Tue, 21 Nov 2000 00:31:59 GMT, timf97_at_earthlink.net wrote:

>I have a Microsoft Access database with tables in it that I need to be
>able to dynamically access from an Oracle 8i (8.1.6) database.
>
>I have figured out how to create a linked table (in the Access
>database) to a table which actually exists in the Oracle database.
>
>What I really need is either a linked table (in the Oracle database)
>to the table which actually exists in the Access database
>(I've tried using the create database link ... (but I must have
>something wrong with it, because I can't get it working).
>
>- or -
>
>Some way to dynamically update the Oracle linked table that I have
>anytime one of the Access tables is changed.
>
>Anybody have any ideas, or advice?

Database links must point to a valid TNSname in tnsnames.ora (if you are using tnsnames). Make sure that is set up properly before attempting to create the link.

Brian Received on Mon Nov 20 2000 - 19:05:46 CST