By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,921 Members | 1,433 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,921 IT Pros & Developers. It's quick & easy.

Querrying Jet and SQL tables

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.