Re: MS Access interface to Oracle 7

From: John Malathronas <John_at_scroll.demon.co.uk>
Date: 1995/05/04
Message-ID: <12370080wnr_at_scroll.demon.co.uk>#1/1

In article: <3nr1r4$ia9_at_dcsun4.us.oracle.com> Mark Vandenbroeck <mvandenb_at_be.oracle.com> writes:
>
> Doug Olson <olson_at_sseos.lbl.gov> wrote:
>
> >The only drawback is that the ODBC interface gives you read only
> >access to the Oracle database, i.e, no adds or updates.
> >
> >Doug Olson
> >LBL
> >
>
> This is not true. You can use MS Access over ODBC to an Oracle database
> and do selects, updates and inserts without any problem.
>
> Mark
>
>

Indeed you can. This is a big problem, because once you have installed ODBC and SQL*Net 2.0 - your users can go directly to the tables and bypass any of your forms, be they Visual Basic or ACCESS or Forms 4.5. Once you have granted update/delete access to a table, thinking that your user will always use a particular form, the user can fire up Access and have access to the table records RAW. It is terrible. It's as if you are giving all your users SQLPLUS access to your database.

---

John Malathronas       | My opinions are my own, so I change them daily. +
-----------------------|                                                 |

john_at_scroll.demon.co.uk| "Only fools learn from their own mistakes " +

-----------------------|---------------------------------------------------

Received on Thu May 04 1995 - 00:00:00 CEST