Re: Oracle and Access difference

My favourite Access-Oracle story is the one about the amateur coder in one of the big bank who prototyped an Access front-end against an access database, then called me to complain about the appalling response from Oracle when he used ODBC to point it at the real database.

Turned out he'd got Access to pull down a 17,000 row table, then joined it one row at a time to some other table so that he could present a drop-down pick-list when the user hit a particular data-entry field.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Boyce G. Williams, Jr. wrote in message <37bd6c11.9269141_at_usenet.acw.vcu.edu>...
>On Thu, 19 Aug 1999 09:39:07 GMT, bgeake_at_my-deja.com wrote:
>I use Access in this manner as well. My beef is: if you use Access
>ODBC for more than just simple SELECTs (multiple tables, correlated
>subqueries, pivot tables, etc) then the processing gets REAL slow. It
>makes me want to hesitate recommending using our Oracle database
>tables as look-up tables to an Access data-entry database. And no, I
>don't mean using Access to enter data to an Oracle database, but
>rather use Oracle to keep an Access database "honest" with correct
>data.
Received on Fri Aug 20 1999 - 10:32:13 CDT