Re: Access 2.0 as front-end
Date: 2 Oct 1994 21:36:02 -0400
Message-ID: <36nn62$jdv_at_newsbf01.news.aol.com>
In article <36n7le$1aae_at_obelix.uni-muenster.de>, pastoor_at_comix.uni-muenster.de (Gero Pastoors) writes:
>Hello everybody,
>I want to develop an application on Oracle using MS-Access 2.0 as
front-end
>tool. I intend to use ODBC an attach the tables I need for my
application.
>How is the performance of ODBC? Is it true that when I develop a query
>Access will receive all records from the server and performs the filter
>afterwards? Or is Access sending an SQL-statement to the Oracle-Server
and
>receives only the required records?
>Gero
ODBC performance is very good if you don't select large numbers of records to be returned to your PC. Access will send the SQL to the Oracle Server as long as your Access Query contains only valid SQL statements. (For example, using the Access IIf statement in a query will cause Access to request the server to send all records to the PC, since IIf is not a valid SQL command.) Received on Mon Oct 03 1994 - 02:36:02 CET