467,075 Members | 1,049 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,075 developers. It's quick & easy.

Querrying Jet and SQL tables

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
Nov 13 '05 #1
  • viewed: 1083
Share:
1 Reply
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

44 posts views Thread by Mariusz Jedrzejewski | last post: by
3 posts views Thread by Random Person | last post: by
11 posts views Thread by dskillingstad@gmail.com | last post: by
59 posts views Thread by phil-news-nospam@ipal.net | last post: by
5 posts views Thread by rdemyan via AccessMonster.com | last post: by
4 posts views Thread by db2admin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.