Re: How a server oracle can read mdb(access) database
From: C. (http://symcbean.blogspot.com/) <colin.mckinnon_at_gmail.com>
Date: Wed, 30 Apr 2008 05:28:47 -0700 (PDT)
Message-ID: <80de2867-95ba-4398-942c-fac3241c3308@56g2000hsm.googlegroups.com>
Date: Wed, 30 Apr 2008 05:28:47 -0700 (PDT)
Message-ID: <80de2867-95ba-4398-942c-fac3241c3308@56g2000hsm.googlegroups.com>
On Apr 30, 11:49 am, Raimo <m0..._at_yahoo.it> 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. Received on Wed Apr 30 2008 - 07:28:47 CDT