Microsoft Access - Oracle8i

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? Received on Mon Nov 20 2000 - 18:31:59 CST