Re: Oracle\Access data communication

On Thu, 28 May 1998, Craig Lawton wrote:

> I'm just wondering if anyone has tried to use MS Access or Visual
> Basic as a front end for data stored in an Oracle database. What are
> the various techniques used in doing this? Potential bugs and
> pitfalls?
>

        Using standard SQL isn't a real pain...actually it's quite easy. When your used to SQL Server or Access DB handling dates can be a pain in the beginning but nothing all that hard. Using something like Jet makes access pretty simple though dealing with some of the "better" things can be a pain (by 'better', I mean things like stored procedures).  

> I actually did this a couple of years ago - set up an Personal Oracle
> database and ODBC drivers on a windows 95 (I think) machine and linked
> Oracle tables from within an Access 2.0 database. The technology
> seemed quite buggy. Has the technology matured? What about new
> technologies such as OLE DB Providers (is there one for Oracle)? What
> about Oracle OLE Objects? Any insight would be much appreciated.
>

        Just got done with a sizable VB project using Oracle as the backend. Went almost without a hitch...

///////////////////////////\\\\\\\\\\\\\\\\\\\\\\\\\\\
// Damond Walker         \\// [moribund_at_netgsi.com] \\
// Will Program For Beer //\\ No job too tough...   \\
//  <<No Vacancy>>       \\// ...no fee too high!   \\
///////////////////////////\\\\\\\\\\\\\\\\\\\\\\\\\\\