Querrying Jet and SQL tables

[Demboos]

Hello everyone,

I'm considering upsizing my databases to SQL server. I've tried the
upsize wizard on one of them, but the process failed since to some
problems on sql server side (probably too complicated structure, names
etc.).

So instead I want to export manually my tables to SQL server and link
them in my Access DB's and leave all queries, forms in my mdb. Also few
tables would be left locally in the mdb file.

I have one specific question considering one-to-many relations between a
table accessed from SQL server and a table in mdb file. Suppose that I
want to fetch a few records from local table and for every row, I want
to fetch corresponding records from SQL table. Normaly (without sql
tables) access is doing a JOIN query, but how does it work when I have
one of the JOIN tables on a SQL server? Does Access fetch ALL records
from this SQL table and then just perform the query locally? Or does
Access optimize the query somehow just to fetch the needed records from
remote table?

It is a pity I can't do a full upsizing, since then all queries are
converted to sql views and stored procedures, so I suppose the problem I
described simply doesn't exist.

Thanks in advance

--
Demboos

[Bas Cost Budde]

Try the module SQL-Tool from my site. It writes a SQL script to create
your table structure in a SQL database.
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
For human replies, replace the queue with a tea