Comments below
HJR
--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources: http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------
"Bastorff" <nospam_at_localhost.zz> wrote in message
news:Z_0L5.900$zd1.2370_at_nntpserver.swip.net...
> I'm also about to look into which options exists for accessing
> an Access database >from< the Oracle server side.
>
> As far as I know, Access makes data available only through
> filesystem type calls, not through network/IP. Then you would
> need some type of networked drive for the database file
> and a unix ODBC driver for Access, I guess.
>
I think you're right on this business about filesystem calls. I've just
been playing with the Oracle ODBC Test application (8.1.6 on W2K) and sure
enough it prompts for the ODBC source, and when you say you want Access, up
pops a Windows Explorer-type navigator so you can click on the relevant mdb.
After that, you can do your standard SQL calls, but it all seems rather
pointless -sort of like opening an Access database with a crippled version
of Access! But yes, point-and-click to the mdb filoe seems the name of the
game.
> Other way around, pushing the data from Access into Oracle
> via ODBC could be done with a VBA based program, for
> automation, but then you would need a "always" running
> client computer.
>
This I have done (via VBA, I mean). Sort of. Usual sort of thing -the
On-Click event of an Access button calls an Append Query (all my tables
having previously been linked -but even that can be done in VB, on the fly).
Wouldn't be too hard to move the thing into the On Timer event, and have it
transfer every 15 minutes, or whatever.
Regards
HJR
> Looking forward to hearing more on this subject...
> Regards,
> /fad
>
> "Mark Styles" <news_at_lambic.co.uk> wrote in message
> news:n51pvsklrt0m21kltkp2lu2rognmhkgpqq_at_4ax.com...
> > On Sun, 29 Oct 2000 16:03:27 +1100, "Howard J. Rogers"
> > <howardjr_at_www.com> wrote:
> >
> > >Access 2000 (and allegedly it hasn't changed much since 95):
> > >
> > >Assuming you have data in Access that you want to get into an Oracle
> > >backend, highlight a table, click File - Export, and in the ensuing
dialogue
> > >box, select for files of type 'ODBC databases'.
> > <snip lots of good info>
> >
> > Thanks for that, but actually I'm trying to find a way to do it the
> > other way around. I.e. I want to make an ODBC call TO Access FROM
> > Oracle, ideally automatically, and even more ideally in a stored
> > procedure (but this might be asking too much!).
> >
> > >You are indeed a brave soul if you are going to try this with Lotus
Notes.
> > >I guess the whole concept of ODBC suggests that it should all work much
the
> > >same, but I don't rate your chances for total sanity at the end of a
week
of
> > >trying!
> >
> > My sanity is already in question, I hate bloated goats with a passion!
> >
>
>
Received on Mon Oct 30 2000 - 04:16:23 CST
