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 |