Re: How a server oracle can read mdb(access) database
by "C. (http://symcbean.blogspot.com/)" <colin.mckinnon@[EMAIL PROTECTED]
>
Apr 30, 2008 at 05:28 AM
On Apr 30, 11:49 am, Raimo <m0...@[EMAIL PROTECTED]
> wrote:
> Hi. I have a server "A" with oracle 10g express (free) and a server
> "B" with an Access database.
> I need that an application that uses oracle server can reads tables on
> "B". How can i do this?
> Can do i make a Local View on "A" of "B"?
> thanks
You can attach odbc tables in Access, but performance sucks big time
when Access tries to resolve queries on remote tables.
Keep all your data in Oracle and use passthrough queries so that
Oracle does the clever stuff. (Or keep everything in Access - but
concurrent access sucks).
C.
