Re: Microsoft Access usage with Oracle (through MS or Oracle ODBC)

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 29 Nov 1998 19:12:24 GMT
Message-ID: <3667ec4b.12593308@netnews.worldnet.att.net>

On Fri, 27 Nov 1998 16:08:06 GMT, "Information Technology, Software" <it2_at_sympatico.ca> wrote:

>A lot of company claims to be Oracle compliant when using (yes) an MS Access
>front end. I hear that Access is not ANSI SQL92 compliant and that problems
>do exist with it's usage (especially when MS Access is used to create the
>Oracle Objects). Since I do not know much about the integration of both
>products and because a vendor wants to sell that solution I am looking to
>see if I such be concerned or not about the integration and it's
>implication.

I've found deploying an Access application that goes against Oracle to be a PITA. In my case, we have a number of Access tables that are mapped to Oracle tables. This makes upgrading a chore. We can't just plop a new version of the Access application in place. We have to manually go in and relink all those tables. We also have to make sure that every user has the appropriate ODBC connection--the name has to match what Access expects--set up on their machine.

Jonathan Received on Sun Nov 29 1998 - 13:12:24 CST