Re: HELP!! ACCESS ODBC ORACLE

aldesai_at_caip.rutgers.edu (Alay) wrote:

>

.. Stuff deleted ...

> Format(TASK.Date1, "yyyy") > (Year(Now()) - 1)
>

Just remember, Microsoft Access is *NOT* a client/server tool. You can access remote databases (via ODBC), but there is no specific support/optimisation for this.

For example, when you create such 'WHERE' conditions, Access wil not even attempt to let the database do the work, but instead will retrieve all the data over the net and do the join locally.

We even obeserved in somme cases, that, with joins like yours, Access sometimes retrieved all the rows from the tables *several* times over the net.

Mark Received on Mon Jan 23 1995 - 10:01:10 CET