Re: Accessing MS Access tables from Oracle ?

From: John Mishefske <mishej_at_execpc.com>
Date: Sun, 17 Mar 2002 19:03:24 -0600
Message-ID: <3c953d22$0$89924$272ea4a1@news.execpc.com>

Rastko wrote:
>
> Thanks to all.
> I agree that's very bad idea to link an mdb file to Oracle
> but the people are still using the mdb applications and I need this for
> one very special case.
>
> Generic Connectivity is included also in 8i.

Access makes a nice front end / report writer for Oracle.

Sounds like a possible solution (temporarily) is to transfer the appropriate Access tables to Oracle for whatever task you need to perform.

You can do this from Access. Create a matching table structure in Oracle and link to it from Access and copy the records forward.

In Access:

DoCmd.TransferDatabase acLink, "ODBC Database", _

        "ODBC;DRIVER={Microsoft ODBC for Oracle};SERVER=ORA8;UID=SCOTT;PWD=TIGER;", _
        acTable, "oracleTable", "accessTable"

-- 
'-------------------------------
' John Mishefske
'-------------------------------

Received on Sun Mar 17 2002 - 19:03:24 CST